Depends on what you're doing. Yes, the isolation level set is just for that session / connection until you specify otherwise, it does not have an affect on other queries running in other sessions etc. The question is, are you doing anything else in that session after you run this query that needs to change the isolation level? If so, then do another SET ISOLATION LEVEL...to a level that fulfills the requirement.