Back to Community Threads
1
Change DB　Owner For SQL 2005,2008,2012 database objects
Problem reported by Greg C. - June 21, 2015 at 7:29 AM
Submitted
Employee Post
Step1: Get All Alter SQL commands(Table,SP,View)
SELECT 'ALTER SCHEMA dbo TRANSFER ' + s.Name + '.' + o.Name
FROM sys.Objects o
INNER JOIN sys.Schemas s on o.schema_id = s.schema_id
WHERE s.Name = 'OldName'
And (o.Type = 'U' Or o.Type = 'P' Or o.Type = 'V')
 
Step2: Select all SQL commands and open a new windows then Execute the SQL Scripts

Reply to Thread

Related Community Threads

babaQuestion by Greg C.-July 26, 2021MCGQuestion by Greg C.-June 19, 2015

Related Knowledge Base Articles

How to Upgrade MS SQL Version05. MSSQL > 06. Upgrade or DowngradeHow to Install DNN Web Site08. Website > 06. DNN WebsiteHow To Change SQL Server 2008/2005 Object Schema?05. MSSQL > 05. Change ConfigurationHow to Install LEMP Stack On Ubuntu 20.0408. Website > 02. Apache & Nginx Web ServiceHow to Install WordPress with LEMP On Ubuntu 20.0408. Website > 07. WordPress Website