Grant Fritchey (7/22/2010)

---

Something along these lines. You have a table with a column, CityName. One row has a value 'Hyderabad.' But that's a bad value. So someone is running a...

2 ways:

/* 1st */

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

SELECT * FROM MyTable

/* 2nd */

SELECT * FROM MyTable WITH (NOLOCK)

I hope this is what you're looking for.