Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Posts
    10

    Unanswered: How to change owner?

    What is the easiest way to change owner of some db object (table, sp, etc.)?

    Thanks!

  2. #2
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    from Books Online:

    Syntax
    sp_changeobjectowner [ @objname = ] 'object' , [ @newowner = ] 'owner'

    Example
    EXEC sp_changeobjectowner 'authors', 'Corporate\GeorgeW'
    Paul Young
    (Knowledge is power! Get some!)

  3. #3
    Join Date
    Jan 2003
    Posts
    10

    Smile

    This was really fast!
    Thank you very much!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •