|
Extraido del BOL del 2005 SQL Server 2005 Books Online sp_changeobjectowner (Transact-SQL) URL: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/45b3dc1c-1cde-45b7-a248-5195c12973e9.htm Changes the owner of an object in the current database. Important: 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. sp_changeobjectowner changes both the schema and the owner. To preserve compatibility with earlier versions of SQL Server, this stored procedure will only change object owners when both the current owner and the new owner own schemas that have the same name as their database user names. Important: A new permission requirement has been added to this stored procedure. Carlos Peix wrote:
--
|
