Browse by Tags

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

Published 22 April 8 3:1 AM | SSQA.net

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...

Filed under: sql server, access, best practices, object, 2005, tsql, schemas, alter authorisation

SQL Server 2005 schema integration changes and use of best practices - use of Schema Qualified Tables/Views

Published 24 January 8 7:19 AM | SSQA.net

You all know that it is a best practice to use the schema qualified tables or views for the better management and performance (sometimes). As the Best Practices Analyzer tool which will be a part of SQL engine from 2008 version onwards confirms that this...

Filed under: sql server, download, version, best practices, 2005, bpa, schemas, tablels, referential integrity, query plans