My database settings are:
SET ALLOW_SNAPSHOT_ISOLATION ON
Does this mean I don't have to explicitly have:
Set Transaction Isolation Level Read Committed
for each proc, i.e. because I have the two settings at the database level there is no need set the Transaction Isolation Level in each proc or does this need to be done as well as the database level settings.
View Complete Post