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

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.

  1. No comments yet.
  1. No trackbacks yet.