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 |
|
vm
Starting Member
1 Post |
 Posted - 2010-10-19 : 18:51:37
|
| i am trying to delete a user in sql server 2005 , the user has his schema objects , so my question is scenario 1. how to change the objects ownership to system administrator scenario 2 . how to send the users objects in to Master Database.Thank one and all for you replies....vn |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2010-10-22 : 09:09:25
|
| To change object ownership use sp_changeobjectowner (see books online for guidance)Why would you want to send user objects to the Master database? Master (a SYSTEM database) should be left in it's installed state for upgrades, reinstalls, etc. Move the objects, if that's what you really want to do, to a USER database (create one if it doesn't exist).Terry-- You can't be late until you show up. |
 |
|
|
|
|
|
change ownership of objects and delete user