August 6, 2016 at 4:21 am
hi,
From bl or web pages some body is calling my stored porcs in serialized isolation , for time been ,i wanted to change it to
read commited in stored proc, becasuse it is easy for me , will it create any problem except the integrity provided by
read commited will be applied for the session of stored proc.
finally we will ask data access layer to start proper isolation , but for time been is it possible to do above
, that is , is it technically ok or there are some considerations.
yours sincerley
August 6, 2016 at 8:53 am
I just realized you posted 3 questions in 30 minutes. These aren't interview questions are they?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 6, 2016 at 3:16 pm
The answer to your question is 'maybe', because there's no where near enough information to answer any other way.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply