Declare @RC INT
Declare @objname nvarchar (517)
Declare @newowner nvarchar (128)
Set @objname = 'xxxxx' - Name
Set @newowner = 'xxxxxxxxxx' - owner
Exec @rc = [dbo]. [Sp_changeObjectowner] @objname, @newowner
Declare @PRNLINE NVARCHAR (4000)
Print 'stored procedure: master.dbo.sp_changeObjectowner'
SELECT @prnline = 'Returns code =' Convert (nvarchar, @RC)
Print @PRNLINE
