Archive for the ‘Other’ Category


May 27, 2012

The purpose of this blog is to record any tricks/tips which I find related to SQL Server. Today it’s 27th May 2012 and Ive ploughing my way through the Service Broker tutorials found on the Microsoft site here Ive been having a little trouble getting the tutorial entitled Completing a Conversation between instances working.

My main problem was that the tutorial wasnt written for 2 instances on the same server, it was written for instances on seperate servers. Here I document the changes I had to make to get it up and running. I’m well aware this could very well be my first and last entry however we shall see.

Please note all sql attachment have the .doc extension due to limitation imposed by wordpress. Please note these are are just plain text files and can be opened in Management Studio or you preferred code editor.