Tuesday, 1 September 2009

Changing table owner in SQL 2000

Note to self, so next time I dont' have to Google it:
EXEC dbo.sp_changeobjectowner @objname = 'Test.TestTable' , @newowner = 'dbo'

No comments:

Post a Comment

Comments are moderated, so you'll have to wait a little bit before they appear!