In a DB I executed
alter database xxx set read_committed_snapshot ON
If I execute
set transaction isolation level read committed
Is the session with isolation level read committed or read committed snapshot?
Read Committed Snapshot. Once turned on, this is in effect for all trans running at Read Committed level.
SQL DBA,SQL Server MVP(07, 08, 09) Prosecutor James Blackburn, in closing argument in the Fatal Vision murders trial: "If in the future, you should cry a tear, cry one for them [the murder victims]. If in the future, you should say a prayer, say one for them. And if in the future, you should light a candle, light one for them."