Friday, August 6, 2010

SQL 2000 change the owner of a table

For SQL 2000 change the owner on a table:


use DB

EXEC sp_changeobjectowner 'UserName.TableName', 'dbo'

No comments:

Related Posts Plugin for WordPress, Blogger...