SQL Server Performance

SQL Server 2005 unable to drop schema error: Cannot drop schema <> because it is being referenced by object

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Apr 22, 2008.

  1. Anonymous New Member

    Recently I have received an email about unable to drop schemas that are adopted in the database design within an environment, here it goes. I'm setting up an automatic build process that also includes building one or more databases. Initially it was decided to used separate databases for various parts of the solution, but after a bit of discussion we landed on using schemas instead. However, that causes problems for the build process as drop schema does not drop all corresponding objects (like drop...(<a href="http://sqlserver-qa.net/blogs/tools/archive/2008/04/22/sql-server-2005-unable-to-drop-schema-error-cannot-drop-schema-because-it-is-being-referenced-by-object.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=4084" width="1" height="1">

Share This Page