I am running a procedure which includes some operations on X table.After couple of minutes I kill the execution of Procedure......
Then I am trying to access the X table by right clilck on it and selecting "Edit Top 200 rows".It is giving SQL Execution Error:TIMEOUT Expired.The timeout period elapsed prior to completion of operation."
I tried following thins but still it didn't work
1)Modifying the SQLServer timeout from 30 to 120
2)used WITH(NOLOCK) in the select statements in Stored Procedure
Please help me in resolving this issue