Back to Community Threads
1
baba
Question asked by Greg C. - June 21, 2015 at 7:30 AM
Unanswered
Employee Post
Step1:
declare @OldOwner varchar(100)
    declare @NewOwner varchar(100)
    set @OldOwner = 'Test1'
    set @NewOwner = 'dbo'
    select 'sp_changeobjectowner ''[' + table_schema + '].[' + table_name + ']'', ''' + @NewOwner + '''
    go'  
    from information_schema.tables where Table_schema = @OldOwner
 
Step 2: Get ALL stored procedured in MS SQL 2000
select specific_name from information_schema.routines
where routine_type='PROCEDURE' and SPECIFIC_Schema='Test1'
select specific_name from information_schema.routines
where routine_type='FUNCTION' and SPECIFIC_Schema='Test1'
 
sp_changeobjectowner '[tenders].[ClienteUsuarioSectorSubSector]', 'dbo'   
go
 

Reply to Thread

Related Community Threads

MCGQuestion by Greg C.-June 19, 2015Change DB　Owner For SQL 2005,2008,2012 database objectsProblem reported by Greg C.-June 21, 2015babaQuestion by ABDALLA MASSANI-February 21, 2023

Related Knowledge Base Articles

How to Install LEMP Stack On Ubuntu 20.0408. Website > 02. Apache & Nginx Web ServiceHow to Install MySQL on Ubuntu 20.0406. MySQL & MariaDB > 01. Installation & UninstallationHow to Install WordPress with LEMP On Ubuntu 20.0408. Website > 07. WordPress WebsiteHow to Install Joomla Web Site08. Website > 08. Other WebsitesMajor Security Vulnerability in WordPress, Drupal Could Take Down Websites08. Website > 07. WordPress Website