Today I needed to change the owner of database schemas and roles after migrating databases from SQL 2000 to SQL 2008 and again did forget how to do this in T-SQL. To never forget again and for those who are looking for the same:
Change Schema owner:
ALTER AUTHORIZATION ON SCHEMA::[<schemaname
Change Role owner:
ALTER AUTHORIZATION ON ROLE::[<rolename
Geen opmerkingen:
Een reactie posten