Error in 'Missing Foreign Key Indexes' SQLCop test

chris_godfree

I don't know if this is a problem with SQLTest's implementation of SQLCop tests or the SQLCop test itself, but the 'Missing Foreign Key Indexes' will only ever return a single error - if there are multiple FK Indexes missing then only one is highlighted. The problem is the ORDER BY statement, once that is removed the test will return all the missing Foreign Key Indexes.

Chris

--ORDER BY OBJECT_NAME(fk.object_id), fk.fk_columns

Rob C

Hi Chris,

Thanks for the information - I've made a note of your suggestion. I'm not aware of our implementation being different but if you wanted to check, you can get SQLCop itself from the SQLCop website.