SQL SERVER – 2005 – Transferring Ownership of a Schema to a User | Journey to SQL Authority with Pinal Dave

One of the blog reader asked me how transfer of ownership of schema to another users. Follow the simple script and you will be able to transfer ownership of schema to another user. ALTER AUTHORIZATION ON SCHEMA::SchemaName TO UserName; GO Reference : Pinal Dave (http://blog.SQLAuthority.com) Continue Reading...

Source: SQL SERVER – 2005 – Transferring Ownership of a Schema to a User | Journey to SQL Authority with Pinal Dave