Intellisense does not work with system tables

tduffy77

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

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

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

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