Oct 8 2009

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

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'

No related posts.

Related posts brought to you by Yet Another Related Posts Plugin.

By aspgod • SQL Server • 0 • Tags: change owner name, owner name, SQL Server, stored procedures