Error in 'Missing Foreign Key Indexes' SQLCop 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.


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


Sign In or Register to comment.