How can we help you today? How can we help you today?

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.

Chris

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

Comments

1 comment

Sort by
  • 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.
    Rob C
    0

Add comment

Please sign in to leave a comment.