In an SQL Server database, when you change the owner of a schema, SQL Server silently drops all the permissions associated with the objecs within that schema. If you are not aware of this, and change the schema owner, you could end up causing some serious issues, and application outages. Surprisingly, this is not a…

Continue Reading