How can we help you today? How can we help you today?

Doesn't detect a "dbo." prefix

Folks,

I like SQL Prompt 3 very much - looks just so much nicer and slicker than before!

However, one thing is bugging me: I often type

select <fields> from dbo.

and then hit Ctrl-Space. Now I can select the table I'm interested in and hit <Enter>, but I end up with:

select <fields> from dbo.[dbo].[T_Checklist] AS tc

It seems SQL Prompt 3 isn't quite smart enough to see that I have ALREADY typed the dbo. prefix - it insists on putting it there by itself. Not nice!

Cheers!
Marc

PS: This is in SQL Server 2005 Management Studio, btw
mscheuner
0

Comments

1 comment

Sort by
  • Bart Read
    Hi Marc,


    Thanks for this, we're aware of this problem. Again, it's something we didn't quite have time to fix for the beta because of course it's not just people prefixing with owners/schemas you have to worry about: you can also (for example) prefix columns with a table or view name so our fix has to be smart enough to handle all of these situations correctly.

    The workaround for now is simply not to type the dbo prefix. Just enter the table name and select from the drop-down. If there are duplicates you'll need to select the one with the correct owner.


    HTH,
    Bart
    Bart Read
    0

Add comment

Please sign in to leave a comment.