why the isolation level is serializable default?
-
16 kwietnia 2012 08:41
Hello all,
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
Regards,
Abby
Get reply from social.microsoft
Wszystkie odpowiedzi
-
16 kwietnia 2012 09:38
Hi,
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 http://ashishmahajancrm.wordpress.com
My Youtube Channel: http://www.youtube.com/user/ashishmahajanmscrm
My Twitter: https://twitter.com/#!/ashishmahajan74My Linkedin: 
