Home Forums SQL Server 2008 SQL Server 2008 Administration The database principal owns objects in the database and cannot be dropped RE: The database principal owns objects in the database and cannot be dropped
zhazhuzhao
Say Hey Kid
Points: 661
More actions
May 5, 2013 at 8:09 pm
#1612502
Lowell (5/3/2013)this blog has a good explanation and the scripts to track down the offending schema:http://blog.sqlauthority.com/2011/12/26/sql-server-fix-error-15138-the-database-principal-owns-a-schema-in-the-database-and-cannot-be-dropped/
Lowell (5/3/2013)
http://blog.sqlauthority.com/2011/12/26/sql-server-fix-error-15138-the-database-principal-owns-a-schema-in-the-database-and-cannot-be-dropped/
Hi, also I tried this way, and the sql didn't return data! I check that use didn't have schema!
Thanks all the same!