Allow users to change the Transaction Isolation Level. Serializable causes problems with linked servers.
Ever since updating to 3.6.0.3, the default Transaction Isolation Level in deployment scripts is Serializable. If a stored procedure has a reference to a linked database it will fail. I have to manually edit every script now and change it to Read Committed...
4
votes
Anonymous
shared this idea