Getting Started with Adobe After Effects - Part 6: Motion Blur
A collection of quick technology learning tips from what people around you learn every day

SQL Server - sp_changeobjectowner can be used to change table owner

Dec 7 2011 10:14PM by RKA   

Inorder to change the owner of the table to dbo, we can do like this.

 
sp_changeobjectowner '<tablename>', 'dbo'
GO
Read More..   [0 clicks]

Published under: SQL Server Tips ·  ·  ·  · 


RKA
92 · 2% · 598
10
 
2
 
 
0
Incorrect
 
0
Interesting
 
0
Forgotten



Submit

1  Comments  

  • This stored procedure only works with the objects available in Microsoft SQL Server 2000. This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use ALTER SCHEMA or ALTER AUTHORIZATION instead

    commented on Dec 8 2011 5:45AM
    harishs
    288 · 0% · 150

Your Comment


Sign Up or Login to post a comment.

"SQL Server - sp_changeobjectowner can be used to change table owner" rated 5 out of 5 by 10 readers
SQL Server - sp_changeobjectowner can be used to change table owner , 5.0 out of 5 based on 10 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]