Intellisense does not work with system tables

tduffy77tduffy77 Posts: 3
edited January 26, 2007 9:30AM in SQL Prompt Previous Versions
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

Comments

  • Bart ReadBart Read Posts: 997 Silver 1
    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
    Principal Consultant
    bartread.com Ltd
  • 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
  • Bart ReadBart Read Posts: 997 Silver 1
    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
    Principal Consultant
    bartread.com Ltd
Sign In or Register to comment.