I use SQL Notifications in one of my database. This is creating SP like this one:

ALTER PROCEDURE [SqlQueryNotificationStoredProcedure-31560677-ebce-4d11-ad0d-5f3524379f90] AS BEGIN BEGIN TRANSACTION; RECEIVE TOP(0) conversation_handle FROM [SqlQueryNotificationService-31560677-ebce-4d11-ad0d-5f3524379f90]; IF (SELECT COUNT(*) FROM [SqlQueryNotificationService-31560677-ebce-4d11-ad0d-5f3524379f90] WHERE message_type_name = 'http://schemas.microsoft.com/SQL/ServiceBroker/DialogTimer') > 0 BEGIN DROP SERVICE [SqlQueryNotificationService-31560677-ebce-4d11-ad0d-5f3524379f90]; DROP QUEUE [SqlQueryNotificationService-31560677-ebce-4d11-ad0d-5f3524379f90]; DROP PROCEDURE [SqlQueryNotificationStoredProcedure-31560677-ebce-4d11-ad0d-5f3524379f90]; END COMMIT TRANSACTION; END

Because these SP are recreated everytime users connects, you need to find a way of keeping these objects outside SQL Connect.