-
sp_changedbowner
what is the proper command for using sp_changedbowner? what all do i need to specify? is it just sp_changedbowner @loginname?
-
sp_changedbowner (reply)
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?
-
sp_changedbowner (reply)
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|