UserData.sp_Blitz Trying to pass a table-valued parameter with 8 column(s) where the corresponding user-defined table type requires 9 column(s). #1429
-
|
Hello, |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment 2 replies
-
|
Is there maybe an older version of sp_Blitz on the other instances? The custom collection requires the data to be returned in the same format on each instance. The data is passed in as a table valued parameter - if the collection returns 9 columns on some instances and 8 on others that will be a problem. sp_Blitz should return: Priority Run it manually and check which column is missing. Note: DBA Dash has the ability to run sp_Blitz on demand via the messaging feature without a custom collection. You might still prefer to use a custom collection to report the data across all instances. |
Beta Was this translation helpful? Give feedback.
-
|
Thanks for your help. The version of sp_Blitz was old as you said. |
Beta Was this translation helpful? Give feedback.
-
|
Great. Glad you got it sorted. |
Beta Was this translation helpful? Give feedback.
Is there maybe an older version of sp_Blitz on the other instances? The custom collection requires the data to be returned in the same format on each instance. The data is passed in as a table valued parameter - if the collection returns 9 columns on some instances and 8 on others that will be a problem.
sp_Blitz should return:
Priority
FindingsGroup
Finding
DatabaseName
URL
Details
QueryPlan
QueryPlanFiltered
CheckID
Run it manually and check which column is missing.
Note: DBA Dash has the ability to run sp_Blitz on demand via the messaging feature without a custom collection. You might still prefer to use a custom collection to report the data across all instances.