Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 change owner to dbo

Author  Topic 

razeena
Yak Posting Veteran

54 Posts

Posted - 2014-04-24 : 01:05:53
Our server had a recently a migration process .The old server had sql2000 and new is sql 2008. The issue is that storesdprocedures owner was changed from 'dbo' to the sqlserver username. Can we change the owner back to dbo for the sps back with any sql script?

Edit: For example, the sp 'dbo.usp_select_candidate'
was changed to 'xyz.usp_select_candidate' after migration. How can i revert back to dbo?

Thanks

WAmin
Starting Member

16 Posts

Posted - 2014-04-24 : 01:15:53
http://technet.microsoft.com/en-us/library/ms178630.aspx
Go to Top of Page

razeena
Yak Posting Veteran

54 Posts

Posted - 2014-04-24 : 05:25:15
Fixed using this.
http://dotnetfish.blogspot.in/2008/04/change-table-and-stored-procedure.html
Go to Top of Page
   

- Advertisement -