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.
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 |
|
|
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 |
|
|
|
|
|