Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Posts
    16

    Unanswered: Change ownership on a table

    Hi,
    Does anyone know the syntax to change the ownership on a table? I want to change it from what it is now to the dbo owner.

    Thanks!

  2. #2
    Join Date
    Dec 2003
    Posts
    61
    sp_changeobjectowner 'owner.tablename','newowner'

  3. #3
    Join Date
    Oct 2003
    Posts
    16

    Smile

    Hi,
    Thanks for the reply, it was actually something that my web host had to do for me, I tried what you suggested but the server wouldnt give permission, thanks for the tip =)

  4. #4
    Join Date
    Dec 2003
    Posts
    61
    Originally posted by krs74
    Hi,
    Thanks for the reply, it was actually something that my web host had to do for me, I tried what you suggested but the server wouldnt give permission, thanks for the tip =)
    You should be the owner or sa to do that job

Posting Permissions

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