Questions tagged [read-committed-snapshot]

For a testing scenario, I need to set read committed snapshot off on an SQL server instance. After the test I need to revert the changes. I use an IF statement to determine which action to perform. Here is the script that I use: USE [master] GO IF…

I need to take a snapshot (SELECT) of some table rows for display. These rows will never be modified or deleted in that same transaction, or transmitted to another transaction which could modify those rows. I only want a simple snapshot-like read in…

I have read committed snapshot isolation and allow isolation ON for my database. I'm still receiving a deadlock error. I'm pretty sure I know what is happening... First transaction gets a sequence number at the beginning of its transaction. Second…

Can you still lock rows exclusively (block readers) in a SQL Server db that has Snapshot Isolation and RCSI enabled? I want to basically do a xlock, rowlock select on a table.