I don't know why the default isolation lelve is 4 now in our system,
just some store procedure need the level 4 from third party,
but when I create a new SP with no specified isolation leve, the default value will be 4,
But when I query from sys.dm_exec_requests, it shows the 'transaction_isolation_level' 2
Does anybody have any idea on it?
How can I set the default isolation level back to 2
Get reply from social.microsoft
Is this question related to Microsoft Dynamics CRM 2011? This area of the forum is related to Microsoft Dynamics CRM 2011.
It would be more helpful to your question if you put it in the right Microsoft forum, may be related to SQL Server.
I hope this helps. If my response was helpful, please vote as helpful.
Ashish Mahajan, CRM Developer, CSG (Melbourne)
My Personal Website: http://www.ashishmahajan.com
My Blogs: http://ashishmahajancrm.blogspot.com.au and
My Youtube Channel: http://www.youtube.com/user/ashishmahajanmscrm