• I appreciate the effort the author has made to install and test the utility and write an article to inform his fellow Sql Server professionals.

    But showing that the utility presents a list of column names after a tablename is used after the FROM keyword and next presenting the statement

    select * from sysconstraints.id

    Where <list of suggestions>

    followed by the remark "I’m sure by now you can see the benefits of this tool if you are unfamiliar with the database schema." is of such poor quality that I had no choice but to rate this article as poor.

    Heck, I was so confused by the authors enthusiasm that I started to doubt my Sql knowledge and tried to execute "select * from sysconstraints.id", thinking it might be a new shorthand notation for "select * from (select id from sysconstraints) c".

    By the way: frankly, I'm dissapointed that the intellisense list in

    select * from sysconstraints.id

    Where <list of suggestions>

    Starts with (or maybe even exclusively contains?!) functions instead of column names from the table after the FROM (or tablenames/aliases if more than one table/alias present). Also I would have expected the _Intelli_Sense utility NOT to suggest column names after a tablename directly following a FROM keyword.

    In the end this article and David le Quesne's comment have been usefull: I'll wait for the al new version 2.0 of this utility before I'll give it a try.

    Edit:

    I noticed that a word of criticism is also in place for myself: I rushed into rating the article as poor and writing this comment after the "select from column" statement, which prevented me from noticing the "what to show in suggestion list" customization option. This could very well invalidate my remark regarding the function names in the list, but I am for sure not the person who is going to test this.

    Edit2: Just noticed that this is the 2.0 version, so, I'll have to wait for the 3.0 version...