«
»

How to change the table owner in Sql Server

Use the sp_changeobjectowner stored procedure.

Synstax:

sp_changeobjectowner ‘OldUser.tableName’, ‘NewUser’

Example

In Domain User

  1. sp_changeobjectowner '[Domain\Username].[tblTableProperty]', 'dbo'

Local User

  1. sp_changeobjectowner '[Username].[tblTableProperty]', 'dbo'

, ,

This entry was posted on Tuesday, May 12th, 2009 at 3:14 am and is filed under Database, MS SQL Server. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

  1. No comments yet.
(will not be published)
Submit Comment

*
To prove you're a person (not a spam script), type the security word shown in the picture. Click on the picture to hear an audio file of the word.
Click to hear an audio file of the anti-spam word

Subscribe to comments feed
  1. No trackbacks yet.

SetPageWidth