Welcome to Sign in | Help

aparitie proceduri stocate

  •  04-29-2011, 4:23 PM

    aparitie proceduri stocate

    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!
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems