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

Intellisense does not work with system tables

I just got this tool today as a prize. First, it looks much more promising than previous versions.

Perhaps I am missing something, but when I use user tables, column names are suggested after the ".", and joins are suggested automatically. When I work with system tables, none of this is true. I do have Include System objects in the candidate list enabled. Ideas, help, bug?

Thanks
Terry
tduffy77
0

Comments

3 comments

Sort by
  • Bart Read
    Hi Terry,


    Thanks for posting. I'm assuming you're working on SQL Server 2005? In which case you should see system views and stored procedures, but you won't see their columns or parameters. This is due to a limitation in the SQL Compare meta-data model which I managed to get around for SQL Server 2000 by using an evil hack, however the same evil hack doesn't work for 2005 unfortunately. We will be addressing this as soon as possible as it's something we all regard as a fairly serious limitaton: it was just a slightly risky change to be making in SQL Compare at the stage we were making it.


    Thanks,
    Bart
    Bart Read
    0
  • tduffy77
    Thanks Bart. Youu are correct this is in SQL05. I see now that it works in SQL 2000.

    One thing, for DBAs this is a serious limitation. I don't spend a lot of time with user tables.

    Terry
    tduffy77
    0
  • Bart Read
    Hi Terry,


    Understood. As I said, it's very much something that's on our agenda. I'm on vacation next week but once I get back I'll be campaigning hard for this to make it into the first point release.


    Thanks,
    Bart
    Bart Read
    0

Add comment

Please sign in to leave a comment.