Thans for your response.

i should use "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED" in my Stored procedure and at the end of stored procedure set it back to default value. Am...