Sunday, January 18, 2009

How to transfer ownership of a schema from one to another user

ALTER AUTHORIZATION ON SCHEMA::SchemaName TO UserName;


Reference : Pinal Dave (http://www.SQLAuthority.com)

No comments:

Post a Comment