Tag Archives: SQL-Server

Changed Owned Schema For User In SQL Server

I accidentally set “Owned Schemas” for a new user in SQL Server 2005 to db_backupoperator and db_owner. Not what I wanted, and then discovered I couldn’t change them back using SQL Management Studio. Oh, well, the following http://blog.sqlauthority.com/2008/04/05/sql-server-2005-transferring-ownership-of-a-schema-to-a-user/ helped out. … Continue reading

Posted in Snippets, SQL Server | Tagged , | Leave a comment