Archive

Posts Tagged ‘owner name’

Change Owner Name for SQL Server (Table, Stored Procedures)

October 8th, 2009 aspgod No comments

Use this command below to change the owner name of table or stored procedures in SQL Server

1
2
exec sp_changeobjectowner 'TABLE_NAME', 'dbo'
exec sp_changeobjectowner 'STORED_PROCEDURES_NAME', 'dbo'