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!sp_changeobjectowner 'owner.tablename','newowner'|||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 =)|||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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment