Error in 'Missing Foreign Key Indexes' SQLCop test
chris_godfree
Posts: 50 Silver 1
in SQL Test
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
Chris
--ORDER BY OBJECT_NAME(fk.object_id), fk.fk_columns
Tagged:
Comments
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.
Redgate Software