Competition: What’s your favorite Redgate tool? Enter now.

Creating Stored Procedures with dependencies Redux

Brian DonahueBrian Donahue Posts: 6,590 New member
edited February 1, 2005 8:59AM in SQL Packager Previous Versions

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.