Find Invalid Objects - Timeouts

• 
  Just to add my vote for this issue and let you know John is not the only one seeing this. We have a few hundred tables and aprox. 2000 procs in our database. Is this something that we are doing wrong or is this not going to work on larger databases like ours?

  CGLuttrell December 17, 2010 00:22

  - 0 +
• 
  Thank you both for your comments. We're not sure yet why this timeout occurs, but we're looking into it.
  
  Regards,
  Paul Stephenson
  SQL Prompt Project Manager
  Red Gate Software

  Paul Stephenson December 17, 2010 03:28

  - 0 +
• 
  Has this been resolved yet?

  carlowahlstedt January 25, 2011 13:38

  - 0 +
• 
  Hi all,
  
  Apologies for going dark on this one for so long.
  
  The cause of the timeouts has now been identified. The Find Invalid Objects operation generates a query plan for each stored procedure in the database. If any one of these query plans takes more than 30 seconds then you will see the timeout error and no results.
  
  For a quick fix, we will be increasing the timeout in SQL Prompt 5.1 to five minutes (unless popular opinion here prefers a different value). If you are impatient to use this feature then please email me at paul.stephenson@red-gate.com and I'll send you a private patch.
  
  Regards,
  Paul

  Paul Stephenson March 07, 2011 03:13

  - 0 +
• 

  Paul Stephenson wrote:

  For a quick fix, we will be increasing the timeout in SQL Prompt 5.1 to five minutes (unless popular opinion here prefers a different value). If you are impatient to use this feature then please email me at paul.stephenson@red-gate.com and I'll send you a private patch.

  
  When do you think 5.1 will be released?

  MikeyC March 07, 2011 13:14

  - 0 +
• 

  CodantiM wrote:

  When do you think 5.1 will be released?

  
  We're aiming to release SQL Prompt 5.1 in April.
  
  Regards,
  Paul

  Paul Stephenson March 09, 2011 03:30

  - 0 +

Add comment

Please sign in to leave a comment.