SQL Server 2005 Transactions
- by mcallec
I have a long running stored proc (approx 30 mins) which is currently running within a transaction (isolation level snapshot).
I've set the transaction to snapshot to avoid locking records preventing other processes from accessing the data.
What I'm trying to do is write to and read from a status table, but although we're in a transaction I'd like…