No database sugestion

• 
  Hi Rui,
  
  Could I check which version of SSMS you're running and which version of SQL Server you're connecting to?
  
  Thanks,
  Aaron.

  Aaron L January 15, 2015 06:22

  - 0 +
• 
  SSMS version 10.50.6000.34
  SQL Server 208 R2

  rreis January 15, 2015 06:48

  - 0 +
• 
  Hi Rui,
  
  Could you try this build and let me know if it works for you? Thanks!
  
  Aaron.

  Aaron L January 15, 2015 07:17

  - 0 +
• 
  Works fine with this version.

  rreis January 15, 2015 07:28

  - 0 +
• 
  Thanks for your help Rui!
  
  It looks like a bug might have been introduced in the 6.4.1.163 build with SSMS2008R2 under some configurations, so we'll get this new build out as soon as possible.

  Aaron L January 15, 2015 07:31

  - 0 +
• 
  Thanks for the support Aaron.

  rreis January 15, 2015 07:35

  - 0 +
• 
  Is this still an issue?
  
  I've just installed SQLPrompt 6.4.1.164, and can't get any object related prompts to appear. I just get the snippet stuff.
  
  Microsoft SQL Server Management Studio 11.0.3000.0
  Microsoft .NET Framework 4.0.30319.18444
  Operating System 6.1.7601
  
  Thanks

  Darren Green February 19, 2015 06:54

  - 0 +
• 
  Hi Darren,
  
  The original issue mentioned in this thread was fixed in 6.4.1.164, however there could be a few reasons for no suggestions being shown. I assume you didn't get any error message popup saying Prompt can't retrieve suggestions from the database?
  
  There's a couple things to check to start with:
  1) Under SQL Prompt->Options->Connections make sure you've got "Load suggestions for all databases" set
  2) Are there any error messages after opening a query against the database listed under SQL Prompt->Help->Show Log?
  
  Thanks,
  Aaron.

  Aaron L February 19, 2015 09:22

  - 0 +

Add comment

Please sign in to leave a comment.