Welcome to Sign in | Help
in Search

aparitie proceduri stocate

Last post 04-30-2011, 2:57 PM by Diana. 3 replies.
Sort Posts: Previous Next
  •  04-29-2011, 4:23 PM 8698

    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!
  •  04-29-2011, 4:59 PM 8699 in reply to 8698

    Re: aparitie proceduri stocate

    Lucrezi cu "query notifications"?
    http://archive.visualstudiomagazine.com/2006_06/magazine/features/rjennings/Listing5.aspx
  •  04-30-2011, 2:54 PM 8700 in reply to 8699

    Re: aparitie proceduri stocate

    folosesc SqlDependency in aplicatia mea
  •  04-30-2011, 2:57 PM 8701 in reply to 8700

    Re: aparitie proceduri stocate

    Atunci "ti se trage" de la SqlDependency.Start- vezi link-ul de mai sus
View as RSS news feed in XML
Powered by Community Server (Commercial Edition), by Telligent Systems