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

TSQL to generate GRANT statements from a database

Published 17 August 7 5:45 AM | SSQA.net

select p . state_desc + ' ' + p . permission_name + ' OBJECT::' + s . name collate Latin1_general_CI_AS + o . name collate Latin1_general_CI_AS + ' TO ' + u . name collate Latin1_general_CI_AS + 'GO' , p .* from sys.database_permissions...

Filed under: sql server, performance, access, permission, system, tsql, grant