Service Broker - Asynchronous Logging - SimonS Blog on SQL Server Stuff

Service Broker - Asynchronous Logging

One of the solutions I am looking to implement is an aysnchronous logging mechanism. Whilst this is not the a truly native messaging solution that Service Broker has all the bells and whistles for, it can still be achieved.

There are a number of aspects that need to be addressed to turn implement such a solution, in looking into these I've been posting on the Service Broker forums and anyone thats been there will have come across Roger Wolter. He has provided a great blog entry on one asepct and that is the use of dialogs you can read it here recycling dialogs. As we are just transferring data and not really messages we the reuse of dialogs is a possible solution.



-
Published 29 September 2006 00:04 by simonsabin

Comments

No Comments