what is the proper command for using sp_changedbowner? what all do i need to specify? is it just sp_changedbowner @loginname?
Printable View
what is the proper command for using sp_changedbowner? what all do i need to specify? is it just sp_changedbowner @loginname?
exec sp_changedbowner 'login name of user'
You should have sysadmin rights or DBO of the database.
Thats all
Hth
------------
jim at 4/24/01 4:51:38 PM
what is the proper command for using sp_changedbowner? what all do i need to specify? is it just sp_changedbowner @loginname?
thanks alot, you'll never know how much that helped me.
------------
Hiku at 4/24/01 11:03:00 PM
exec sp_changedbowner 'login name of user'
You should have sysadmin rights or DBO of the database.
Thats all
Hth
------------
jim at 4/24/01 4:51:38 PM
what is the proper command for using sp_changedbowner? what all do i need to specify? is it just sp_changedbowner @loginname?