Bulk change object for SQL Server database owner

Because some sites are using virtual hosts. Using Sql-server to guide the data, the database user defaults to the user you are logged on to, not dbo, sometimes inconsistent with the local generation.

--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

Batch modification:
exec sp_msforeachtable ' exec sp_changeobjectowner ', ' the ' dbo '
Single modification:
EXEC sp_changeobjectowner ' To change the name of the table ', ' dbo '

Method One: Directly click on the table-"Design-" Properties-"Change the above owner." This method is intended for cases where there are few tables.

Method Two: Use script to execute directly, use SYSTEM account or super user to log into this database, then execute the following statement:
sp_configure ' allow updates ', ' 1 '
Go
Reconfigure with override
Go
Update sysobjects set uid=1 where uid<>1--can be arbitrarily modified to switch between multiple users, depending on the conditions.
Go
sp_configure ' allow updates ', ' 0 '
Go
Reconfigure with override

please contact the site, timely note your name. Contact Email: edu#chinaz.com (change # to @).