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 |
|
danielhai
Yak Posting Veteran
50 Posts |
 Posted - 2002-07-01 : 22:10:22
|
| Simple question, how do you change the creator of a table to be dbo, rather then a specific user? I looked around for nearly an hour in books online, and couldn't find anything ... ???thanks,d |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-07-02 : 02:08:40
|
| look at sp_changeobjectowner in BOL.ok wait. this article will help you to do it for a batch of objects.http://www.sqlteam.com/item.asp?ItemID=1283-------------------------What lies behind you and what lies ahead of you are small matters compared to what lies within you.-Ralph Waldo Emerson |
 |
|
|
|
|
|
Changing Ownership