DECLARE @SQL VARCHAR(MAX),
@PrintSQL BIT = 1,
@ExecSQL BIT = 1
SELECT @SQL = Util.dbo.StringConcat('USE ' + NAME + '
SET NOCOUNT ON
GO
DECLARE @SQL VARCHAR(MAX)
SELECT @SQL = Util.dbo.StringConcat(''DROP SCHEMA ['' + s.name + '']'', ''
'')
FROM sys.schemas s LEFT OUTER JOIN sys.database_principals p ON p.name = s.name
LEFT OUTER JOIN sys.server_principals sp ON sp.name = s.name
WHERE (sp.name IS NOT NULL OR p.name IS NOT NULL)
AND s.name LIKE ''%\%''
EXEC Util.dbo.PrintLargeText @SQL
EXEC (@SQL)
SELECT ''' + NAME + ''' AS DatabaseName, s.name AS SchemaName
FROM sys.schemas s LEFT OUTER JOIN sys.database_principals p ON p.name = s.name
LEFT OUTER JOIN sys.server_principals sp ON sp.name = s.name
WHERE (sp.name IS NOT NULL OR p.name IS NOT NULL)
AND s.name LIKE ''%\%''', '
GO
')
FROM sys.databases (NOLOCK)
IF @PrintSQL = 1
EXEC Util.dbo.PrintLargeText
@SQL
GO