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
Dmytro
0

Comments

1 comment

  • 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. :smile:

    Best wishes,

    Michael Clark
    Technical Lead, SQL Prompt
    Michael Clark
    0

Add comment

Please sign in to leave a comment.