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 |
|
shaggy
Posting Yak Master
248 Posts |
 Posted - 2009-08-12 : 06:35:30
|
| Hi,I want to change schema owner of objects from dbo to new schema nameis it possible.eg:select * from dbo.testtoselect * from newschema.test |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-08-12 : 06:49:32
|
| sp_changeobjectowner, look up the syntax in BOL. |
 |
|
|
shaggy
Posting Yak Master
248 Posts |
Posted - 2009-08-12 : 10:00:35
|
| I want to change it for all the objects instead of looping. |
|
|
|
|
|
|
change schema owner