Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Time Out Error When trying to Edit a Table Expand / Collapse
Author
Message
Posted Thursday, September 27, 2012 3:06 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 4, 2012 11:48 PM
Points: 4, Visits: 28
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
Post #1365110
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse