You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The data type of these columns in the view are defined as BIT but they are INT values in the stored procedure:
-- [Retention] BIT NOT NULL -- Hours since the last execution of the query.
-- [MinExecutionCount] BIT NOT NULL -- Minimum number of executions NOT delete the query.
,[CleanupParameters].value('(/Root/CleanupParameters/Retention)[1]','BIT') AS [Retention]
,[CleanupParameters].value('(/Root/CleanupParameters/MinExecutionCount)[1]','BIT') AS [MinExecutionCount]
The correct definition is INT to match the input parameters of the stored procedure.
Regards
Jason
The text was updated successfully, but these errors were encountered:
Hello,
The data type of these columns in the view are defined as BIT but they are INT values in the stored procedure:
-- [Retention] BIT NOT NULL -- Hours since the last execution of the query.
-- [MinExecutionCount] BIT NOT NULL -- Minimum number of executions NOT delete the query.
,[CleanupParameters].value('(/Root/CleanupParameters/Retention)[1]','BIT') AS [Retention]
,[CleanupParameters].value('(/Root/CleanupParameters/MinExecutionCount)[1]','BIT') AS [MinExecutionCount]
The correct definition is INT to match the input parameters of the stored procedure.
Regards
Jason
The text was updated successfully, but these errors were encountered: