Posts Tagged ‘Database’
How to change the table owner in Sql Server
Posted by: admin in Database, MS SQL Server on May 12th, 2009
Use the sp_changeobjectowner stored procedure.
Synstax:
sp_changeobjectowner ‘OldUser.tableName’, ‘NewUser’
Example
In Domain User
-
sp_changeobjectowner '[Domain\Username].[tblTableProperty]', 'dbo'
Local User
-
sp_changeobjectowner '[Username].[tblTableProperty]', 'dbo'