January 11, 2009 at 4:54 am
Hi all,
who knows where I can find more about standard contracts:
http://schemas.microsoft.com/SQL/Notifications/PostEventNotification,
http://schemas.microsoft.com/SQL/Notifications/PostQueryNotification,
http://schemas.microsoft.com/SQL/ServiceBroker/ServiceEcho,
http://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic,
http://schemas.microsoft.com/SQL/ServiceBroker/BrokerConfigurationNotice?
MP
January 11, 2009 at 10:24 am
What do you need to know about them?
Also, why do you need this? I believe that all of these Queues are for internal use only.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
January 11, 2009 at 11:13 am
Books online has good info.
"create event notivication" and further...
Be sure to use the most recent one (dec.2008)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
January 11, 2009 at 12:20 pm
There is no information about those contracts:
http://schemas.microsoft.com/SQL/ServiceBroker/ServiceEcho
http://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic.
First contract implements "ping" to the service broker instance (I think). The second contract implements message Query sent by initiator and Status i Description sent by target. So I think it is a method to diagnose service broker. But how to apply query for this contract? Where is XSD document describing query structure? Is it used only for internal purposes? So why expose it?
MP
January 11, 2009 at 4:11 pm
Powichrowski Marek (1/11/2009)
There is no information about those contracts:http://schemas.microsoft.com/SQL/ServiceBroker/ServiceEcho
http://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic.
First contract implements "ping" to the service broker instance (I think). The second contract implements message Query sent by initiator and Status i Description sent by target. So I think it is a method to diagnose service broker. But how to apply query for this contract? Where is XSD document describing query structure? Is it used only for internal purposes? So why expose it?
They are "exposed" because they have no choice: all tables and queues in a database are visible to us.
But, I am still waiting for you to answer my questions.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
January 11, 2009 at 11:23 pm
RBarryYoung (1/11/2009)
What do you need to know about them?Also, why do you need this? I believe that all of these Queues are for internal use only.
Those not queues but contracts. I need it because I want to use it (especially diagnostic contract).
MP
January 12, 2009 at 4:55 am
I think I know the solution of my problem.
Because messages guaranteed by those contracts has WELL_FORMED_XML validation so is up to developer imagination what they can deliver to receiver.
There is no XSD validation for it.
So I can write my own content for messages (but as well formed xml):
[http://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic/Description],
[http://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic/Query],
[http://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic/Status],
[http://schemas.microsoft.com/SQL/ServiceBroker/ServiceEcho/Echo]
MP
January 12, 2009 at 7:04 am
Powichrowski Marek (1/11/2009)
RBarryYoung (1/11/2009)
What do you need to know about them?Also, why do you need this? I believe that all of these Queues are for internal use only.
Those not queues but contracts. I need it because I want to use it (especially diagnostic contract).
OK, I see now.
AFAIK, their semantic meanig/definition is set entirely by the Service Procedure of the queue that receives them. For the MS supplied queues that may use them, this has not been documented or otherwise discussed (though you may be able to figure it out by dumping the listings of the Ms supplied SQL procs that use these queues).
However, if you are going to use them yourself, then I guess you could also define them yourself, though you would probably be just as weel off defining entirely new messages & contracts for this. That way at least, if MS changed their (syntactical) definition down the road, it would not affect you.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
January 12, 2009 at 7:23 am
Indeed, a word of caution should be said.
Undocumented surely means the behaviour may change with every hotfix/cumulative update/service pack/new version.
They may even be removed without any notification or alternative !
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply