Time Out Error When trying to Edit a Table

• Luhar

  SSC Enthusiast

  Points: 188

  More actions

  September 27, 2012 at 3:06 am

  #100494

  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