About SQL data table Stored Procedure table name prefix into dbo code, sqldbo

About SQL data table Stored Procedure table name prefix into dbo code, sqldbo

1. Replace all table names with dbo

<span style="font-size:18px;">EXEC sp_MSforeachtable 'exec sp_changeobjectowner ''?'',''dbo'' '</span>

2. replace all stored procedures with dbo

<Span style = "font-size: 18px;"> create procedure dbo. changeObjectOwner @ OldOwner as NVARCHAR (128) = 'dbo', -- parameter original owner @ NewOwner as NVARCHAR (128) = 'dbo' -- New Parameter 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 curObjectGO </span>

Then run

<Span style = "font-size: 18px;"> exec ChangeObjectOwner 'database', 'dbo' </span>