Results 1 to 3 of 3

Thread: sp_changedbowner

  1. #1
    jim Guest

    sp_changedbowner


    what is the proper command for using sp_changedbowner? what all do i need to specify? is it just sp_changedbowner @loginname?

  2. #2
    Hiku Guest

    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?

  3. #3
    jim Guest

    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
  •