http://sqlserver.ro/forums/16/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlserver.ro/forums/thread/8701.aspxSat, 30 Apr 2011 11:57:51 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8701Diana0http://sqlserver.ro/forums/thread/8701.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=8701Atunci "ti se trage" de la SqlDependency.Start- vezi link-ul de mai sushttp://sqlserver.ro/forums/thread/8700.aspxSat, 30 Apr 2011 11:54:06 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8700ThePuiu0http://sqlserver.ro/forums/thread/8700.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=8700folosesc SqlDependency in aplicatia meahttp://sqlserver.ro/forums/thread/8699.aspxFri, 29 Apr 2011 13:59:45 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8699Diana0http://sqlserver.ro/forums/thread/8699.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=8699Lucrezi cu "query notifications"? <br />http://archive.visualstudiomagazine.com/2006_06/magazine/features/rjennings/Listing5.aspxhttp://sqlserver.ro/forums/thread/8698.aspxFri, 29 Apr 2011 13:23:23 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8698ThePuiu0http://sqlserver.ro/forums/thread/8698.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=8698Salut, 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: <br />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 <br /> <br />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). <br /> <br />Multumesc anticipat! Daca e necesar revin cu alte detalii!