Salut, am un sever SQL Express 2005 pe care e pusa o baza de date la care este activar serviciul Broker. Totul merge bine, mai putin faptul ca imi apar periodic (si nu mai dispar) proceduri stocate de genul:
ALTER PROCEDURE [dbo].[SqlQueryNotificationStoredProcedure-9920d496-7183-4bf8-be0c-ca28985f0da8] AS BEGIN BEGIN TRANSACTION; RECEIVE TOP(0) conversation_handle FROM [SqlQueryNotificationService-9920d496-7183-4bf8-be0c-ca28985f0da8]; IF (SELECT COUNT(*) FROM [SqlQueryNotificationService-9920d496-7183-4bf8-be0c-ca28985f0da8] WHERE message_type_name = 'http://schemas.microsoft.com/SQL/ServiceBroker/DialogTimer') > 0 BEGIN DROP SERVICE [SqlQueryNotificationService-9920d496-7183-4bf8-be0c-ca28985f0da8]; DROP QUEUE [SqlQueryNotificationService-9920d496-7183-4bf8-be0c-ca28985f0da8]; DROP PROCEDURE [SqlQueryNotificationStoredProcedure-9920d496-7183-4bf8-be0c-ca28985f0da8]; END COMMIT TRANSACTION; END
Ma poate lamuri cineva ce sint si de ce apar si mai ales ce ar trebui sa fac sa nu mai apara? Nu am reusit sa-mi dau seama singur ce le genereaza (daca e o problema a aplicatiei care foloseste baza de date).
Multumesc anticipat! Daca e necesar revin cu alte detalii!