Could not find stored procedure 'dbo.usp_sqlwatch_config_sqlserver_set_blocked_proc_threshold'.
Did you check DOCS to make sure there is no workaround? YES
Describe the bug In a fresh new installation of SQLWATCH, following this guide (https://docs.sqlwatch.io/configuration/basics/) if I run
--default threshold will be 15 seconds:
exec [dbo].[usp_sqlwatch_config_sqlserver_set_blocked_proc_threshold]
I receive the error:
Msg 2812, Level 16, State 62, Line 2
Could not find stored procedure 'dbo.usp_sqlwatch_config_sqlserver_set_blocked_proc_threshold'.
Completion time: 2021-12-20T13:44:45.9039086+01:00
And is the same for all the rest of the queries.
I'm running them on master
To Reproduce Steps to reproduce the behavior:
- Install SQLWATCH through
Install-DbaSqlWatch -SqlInstance localhost -Database SQLWATCH - Install also
Install-DbaWhoIsActive -SqlInstance localhost -Database master - Run on
master
--default threshold will be 15 seconds:
exec [dbo].[usp_sqlwatch_config_sqlserver_set_blocked_proc_threshold]
and I receive the error:
Msg 2812, Level 16, State 62, Line 2
Could not find stored procedure 'dbo.usp_sqlwatch_config_sqlserver_set_blocked_proc_threshold'.
Completion time: 2021-12-20T13:44:45.9039086+01:00
Expected behavior The query shoud execute without errors
Screenshots If applicable, add screenshots to help explain your problem.
Windows Server (please complete the following information):
- OS Version: Windows 10 Enterprise
SQL Server (please complete the following information):
- SQL Version:
Microsoft SQL Server 2019 (RTM-CU14) (KB5007182) - 15.0.4188.2 (X64) Nov 3 2021 19:19:51 Copyright (C) 2019 Microsoft Corporation Developer Edition (64-bit) on Windows 10 Enterprise 10.0 <X64> (Build 19042: ) (Hypervisor)
SQL Server Management Studio (SSMS -> about -> copy info):
- paste "about" info here:
SQL Server Management Studio 15.0.18390.0
SQL Server Management Objects (SMO) 16.100.46521.71
Microsoft Analysis Services Client Tools 15.0.19714.0
Microsoft Data Access Components (MDAC) 10.0.19041.1
Microsoft MSXML 3.0 6.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 10.0.19042
SQLWATCH version (from DACPAC or from sysinstances)
- latest as per today
Additional context
I'm running this non master, should I run it on another DB?