- Code: Select all
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
PRINT N'Dropping schemata'
DROP SCHEMA [Test]
I don't want this schema to be dropped and i don't know why it would it has nothing to do with the table or sp being created. If I use sql compare it is not in the generated scripts.
Is there some option that is causing this that I need to include? I'm using the same options that are the default in sql compare in my code.[/code]