Forum Replies Created

Viewing 2 posts - 1 through 3 (of 3 total)

  • RE: Changes to data during a sproc run

    That's exactly what I was doing 🙂 but I thought there had to be another way. Do you think that the Snapshot solution would incur too much of an overhead?...

  • RE: Changes to data during a sproc run

    Thanks Dave. It seems I'd need to add

    SET TRANSACTION ISOLATION LEVEL SNAPSHOT

    since I'd like to disregard any changes made outside the current process. It appears that I can set this...

Viewing 2 posts - 1 through 3 (of 3 total)