sql - MSSQLServer Logging Many Missing Stored Procedure Messages -

sql - MSSQLServer Logging Many Missing Stored Procedure Messages -

we deleted stored procedures related query notification service since not using them anymore. after deleting procs seeing error log getting filled messages below.

how stop such errors.

the activated proc '[dbo].[sqlquerynotificationstoredprocedure-1c5b775e-e036-4181-8336-ba86d97d763d]' running on queue 'database.dbo.sqlquerynotificationservice-1c5b775e-e036-4181-8336-ba86d97d763d' output following: 'could not find stored procedure 'dbo.sqlquerynotificationstoredprocedure-1c5b775e-e036-4181-8336-ba86d97d763d'.'

try this. run name of queue

select * sys.service_queues

then run

drop queue queuename

sql sql-server sql-server-2008