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 to write to and read from the status table as if I'm not in a transaction. I need this so that other processes can read any updates to this table by my stored proc, and this stored proc can also read any inserts made by other processes.

I realise that having my entire stored proc running within a transaction isn't recommended, but this has been done for other reasons and we need to stick with that approach.

So my question is within a transaction, is it possible to execute a query or call a stored proc which effectively isn't enlisted in the transaction?