To change the object of the database owner

Objects | data | database
--Feature Description: Batch change object for database owner
--Author: unknown
--Usage: exec changeobjectowner ' nmkspro ', ' dbo '
--You can change all Nmkspro owner objects to dbo all
--"Note: Changing any part of an object name can corrupt scripts and stored procedures," he said after a successful run. "
CREATE PROCEDURE dbo. Changeobjectowner
@OldOwner as NVARCHAR (128),--parameter original owner
@NewOwner as NVARCHAR (128)--parameter new owner
As

DECLARE @Name as NVARCHAR (128)
DECLARE @Owner as NVARCHAR (128)
DECLARE @OwnerName as NVARCHAR (128)

DECLARE Curobject CURSOR for
Select ' Name ' = name,
' Owner ' = user_name (UID)
From sysobjects
where user_name (UID) = @OldOwner
Order BY name

OPEN Curobject
FETCH NEXT from Curobject into @Name, @Owner
while (@ @FETCH_STATUS =0)
BEGIN
If @Owner = @OldOwner
Begin
Set @OwnerName = @OldOwner + '. ' + RTrim (@Name)
EXEC sp_changeobjectowner @OwnerName, @NewOwner
End

FETCH NEXT from Curobject into @Name, @Owner
End

Close Curobject
Deallocate Curobject
Go