Post reply

Service Broker Queue

  • October 27, 2015 at 5:01 am

    #312455

    Hi Experts,

    Got the task of moving changes from one DB to another and i found service broker queue like the one below

    CREATE QUEUE [SqlQueryNotificationService-0f3df40e-38f2-430a-bb2d-a16a2f5b1f8e] WITH STATUS = ON , RETENTION = OFF , ACTIVATION ( STATUS = ON , PROCEDURE_NAME = [SqlQueryNotificationStoredProcedure-0f3df40e-38f2-430a-bb2d-a16a2f5b1f8e] , MAX_QUEUE_READERS = 1 , EXECUTE AS OWNER ), POISON_MESSAGE_HANDLING (STATUS = ON) ON [PRIMARY]

    GO

    Is it necessary to move these queues? when and how they are created?

  • October 28, 2015 at 6:58 am

    #1836016

    Got the task of moving changes from one DB???

    What exactly are you moving within the DB. What changes??

    To which DB?

  • November 1, 2015 at 1:37 am

    #1836919

    Changes in objects ,new objects

  • November 2, 2015 at 2:53 am

    #1837006

    These are queues generated for Query Notifications. They are dynamically created for each query notification requested by a client. There is no need to transfer these into your new database.

    More info on Query Notifications: https://msdn.microsoft.com/en-us/library/t9x04ed2(v=vs.110).aspx


    Posting Data Etiquette - Jeff Moden[/url]
    Posting Performance Based Questions - Gail Shaw[/url]
    Hidden RBAR - Jeff Moden[/url]
    Cross Tabs and Pivots - Jeff Moden[/url]
    Catch-all queries - Gail Shaw[/url]

    If you don't have time to do it right, when will you have time to do it over?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply