Snapshot Isolation & Connection Pooling

In case you do open a transaction using isolation level snapshot, make sure you do not disable connection pooling in the connection string (do not set 'Pooling=false').

Otherwise, opening a connection after you opened and closed another one, you will receive an exception telling the transaction cannot be extended.

Leave a Comment

Please note that every comment requires the admin's approval before it will be published.

Any comment containing spam like "... great topic. Feel free to visit my web page ..." will be deleted. So please do not waste your and our time by leaving such comments.

We respect your privacy. When you leave a comment, your IP address will not be recorded by WordPress.