What would happen if I remove all the NOLOCK statements from SProcs in a 3rd party app?
Will I get DEADLOCKS that I never had before? Or will I just get some blocking?
I'm wondering if I had two users:
SELECT * FROM TABLE_A WITH (NOLOCK) WHERE ColA=1 UDPATE TABLE_B SET ColB=2 WHERE ColB=1
SELECT * FROM TABLE_B WITH (NOLOCK) WHERE ColB=1 UDPATE TABLE_A SET ColA=2 WHERE ColA=1
whether that would cause no problem with NOLOCK but would cause DEADLOCK if I took the NOLOCK out?