SqlPromt Glitch

Dnv

I have databases Gps and Raw(which contains table gps).
In Sql Managment I am creating new query window connected to Raw and making query

select ... from gps

when I try to select columns from intellisense, it suggests nothing because it thinks that I typed database name Gps, ignoring the fact that table gps exists in current db.
But next query works good.

select ... from dbo.gps

Michael Clark

Hi Dnv,

Thanks for reporting the lack of column suggestions in that scenario. I have reproduced this in SQL Server 2014 with the latest version of SQL Prompt.

I have logged this as a bug under reference SP-6251 and we will get back in touch if we find a fix.

Best wishes,

Michael Clark
Technical Lead, SQL Prompt