No database sugestion

rreis

Hi,
After update to version 6.4.1.163, when i type select * from no database suggestion appears.
Also the tab option in * to expand wildcard does not shows.
I rollback to version 6.4.0.184 and everything works again.

Thanks,
Rui Reis

Aaron L

Hi Rui,

Could I check which version of SSMS you're running and which version of SQL Server you're connecting to?

Thanks,
Aaron.

rreis

SSMS version 10.50.6000.34
SQL Server 208 R2

Aaron L

Hi Rui,

Could you try this build and let me know if it works for you? Thanks!

Aaron.

rreis

Works fine with this version.

Aaron L

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.

rreis

Thanks for the support Aaron.

Darren Green

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

Aaron L

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.