By following display database change notification using signalR
Everything works well in updating the UI in realtime, but then shows an error on every DML in the database like:
UPDATE Jobs
SET [Status] = 1,
[Result] = ''
WHERE [CertificateId] = 4108890
Msg 592, Level 16, State 1, Procedure tr_dbo_Jobs_78e1a4fd-604c-464f-87ec-341a981ede5c_Sender, Line 44 [Batch Start Line 3]
Cannot find object ID 1637580872 in database ID 8
After investigation, I found it creates a stored procedure
[dbo].[dbo_Jobs_78e1a4fd-604c-464f-87ec-341a981ede5c_QueueActivationSender]
Note: there is no reference to 1637580872 in the stored procedure created