Creating Stored Procedures with dependencies Redux
Brian Donahue
Posts: 6,590 Bronze 1
Hello,
That certainly looks like it would work. I don't know for sure if there would be any unintended side-effects though! Books Online contains an ominous warning about this:
Since SQL Packager scripts make heavy use of transactions, this may not be a good idea. You can set SQL Packager's settings to 'not include transactional plumbing', but that means that the transaction will not roll back if an error occurs and your database will be left in an 'in-between' state.
That certainly looks like it would work. I don't know for sure if there would be any unintended side-effects though! Books Online contains an ominous warning about this:
The compatibility level should not be changed inside a batch of Transact-SQL statements.
Since SQL Packager scripts make heavy use of transactions, this may not be a good idea. You can set SQL Packager's settings to 'not include transactional plumbing', but that means that the transaction will not roll back if an error occurs and your database will be left in an 'in-between' state.
This discussion has been closed.
