The database I'm working on is in SQL SERVER 2008 and has SNAPSHOT isolation ON (See below). This was set by executing the following: ALTER DATABASE testdb SET ALLOW_SNAPSHOT_ISOLATION ON SELECT snapshot_isolation_state_desc from sys.databases where name='testdb' --Output: snapshot_isolation_state_desc ON My question is, for just one stored procedure I want the isolation level to be set to READ COMMITTED. Should I mention the following within that stored procedure? SET TRANSACTION ISOLATION LEVEL READ COMITTED Question 1: Will this overwrite the SNAPSHOT isolation level that was set at the whole db level? Question 2: Will the READ COMMITTED isolation level only apply to that stored procedure? Question 3: Once the stored procedure completes, will the isolation level revert back to SNAPSHOT isolation level? Thanks!