Topic
No replies
SystemAdmin
SystemAdmin
11979 Posts
ACCEPTED ANSWER

Pinned topic isolation level read commited snapshot

‏2012-11-19T12:52:39Z |
i have a application deployed on webspehre and the datasourse we have using is sql server 2008 r2
at database level the isolation level we have set is "read_commited_snapshot", but
at webspehre when a request is send on database it is in read comited mode. that leads to locking issue and i want
that to change the isolation level at webspehere to "read_commited_snapshot".

please suggest .