MSSQL 2000 changes the owner of tables and stored procedures

Change the owner of a stored procedure:

Declare TB cursor local
Select 'SP _ changeobjectowner '[' + Replace (user_name (UID), ']', ']') + ']. ['
+ Replace (name, ']', ']') + '] '', ''dbo '''
From sysobjects
Where xtype in ('U', 'V', 'P', 'tr', 'fn ', 'if', 'tf') and status> = 0
Open TB
Declare @ s nvarchar (4000)
Fetch TB into @ s
While @ fetch_status = 0
Begin
Exec (@ s)
Fetch TB into @ s
End
Close TB
Deallocate TB
Go

 

Change the table owner:

Exec sp_msforeachtable 'exec sp_changeobjectowner "? "," DBO "'

 

==================

When running, an error warning will be prompted, regardless of it, you can run it again.