I read this topics:
SQL Server 2014 reseting isolation level
How do I unset/reset a transaction isolation level for SQL Server?
What does sp_reset_connection do?
And so many posts and blogs...
I have some questions about this topics:
I couldn't find a reliable reference from Microsoft sites that explain reset
ISOLATION LEVELin SQL Server 2014 andsp_reset_connection. How can I be sure that this happened andISOLATION LEVELreset to it's default value.Does it correct that changing
ISOLATION LEVELin stored procedures, just have scope in the scope of the stored procedure? Doesn't it affect connection?
Thanks