Hi, I am converting a console application to run from Service Broker in SQL Server 2005. The application makes heavy use of DataSet. Are DataSets supposed to work in SQLCLR? How do I define the connection to use? Is there any documentation about this? Thanks for your help! ...
I have many operations in the database that need to trigger application code. Currently I am using database polling, but I hear that SQL Server Service Broker can give me MSMQ-like functionality. Can I listen to SQL Server Service Broker queues from .NET applications running on a different machine? If so, should I do it? If not, what w...
I've got a stored procedure that puts a message on a SQL Server Service Broker message queue. I need to return an error message from the stored procedure if something goes wrong and the message doesn't get placed on the message queue. The problem I am seeing is that even if the SQL Server Service Broker is disabled (which is how I'm tr...
Hi, I've been using the scripts from this website to help configure Service Broker based auditing. The first stage - setting up SB between databases on the same instance works fine. But then, when I try to apply Service Broker between instances, I'm running into grief. I'm using the command line tool, ssbdiagnose to help me find the c...
Hi all, I have two servers, the first one with SQL Server 2005 and the second one with SQL Server 2000. I want to insert data from the 2005 to the 2000 and I want to do it unsync (without distributed transactions because "save transaction" are used). Once the information is inserted in the tables of the 2000 server, some instead-of tri...
Hello, We have several ASP.NET applications that use a sitemap which is populated via a VB.NET implementation of the SqlSiteMapProvider example found at Wicked Code. It is compiled to a DLL, then installed and referenced from the GAC on the servers and from our locals as well. It has been working in production just fine for a few months...
Greetings Is there a ORM (MS-Sql specific) that can work with transactions and is Service Broker friendly. What I’m searching for is the ability to work with the ORM tables, inside a transaction, and be able to do service broker calls inside the transaction (either by using an ORM object/method or by directly executing a command.Execute...
Hi there, could I send messages from one service to multiple service using service brokers? Something like BEGIN DIALOG CONVERSATION @dialog_handle FROM SERVICE [SERVICE1] TO SERVICE 'SERVICE2',**'SERVICE3'** ON CONTRACT [MainContract] Looking at the syntax, I do not think we could do this. What's the alternative? Thanks...
I am contemplating converting our internal application from MSMQ and WCF to SSB. We would like a more feature rich system with regards to our queuing. However, I am not seeing a lot of implementations or general information if SSB is in use with .Net. The SSB blog is not very active and I see few posts in general on implementation s...
Is there a .Net API or object model for using SQL Service Broker? ...
I've asked about each of these technologies separately, and really haven't found a suitable answer. We have a server in our central office running SQL Server 2005 Enterprise that has several large (large in the sense that DSL is the limiting factor) databases that we need local copies of at each of our locations. We currently have a fe...
We currently have an application that uses service broker to queue messages to sent to an external system, which we communicate with via a web service interface. At present we only integrate with a single company, so one queue is sufficient - however we need to start passing messages to multiple companies who all use the same web servic...
I am using service broker as my messaging system to schedule and run jobs. Eash job is composed of multiple tasks or steps called engines. My service broker objects are: MessageTypes: SubmitJob, JobResponse, SubmitTask, TaskResponse Contracts: JobContract, TaskContract Queues: ClientQueue, JobQueue, EngineQueue, ExternalActivatorQue...
Are there any good options for connecting two SQL Server 2008 instances via Service Broker if neither of those servers are in a domain, but we have full control over the logins and credentials? We're thinking of using this technology for enterprise-level data consolidation, but our servers run at client sites and are not configured as m...
I've just inherited a SQL Server 2005 database that's using service broker (this is part of a bigger project/solution). Everything about the solution is working fine. I'm trying to grok the service broker SQL, and I see this statement. BEGIN DIALOG CONVERSATION @h FROM SERVICE foo_Init TO SERVICE 'foo_Target' ON CONTRACT fooContract ...
I am trying to configure auditing on my SQL Server using Service Broker. I did all the configuration needed to capture the DDL Events (queue, routes, endpoints, event notification). It is working properly except that I am not able to get the hostname of the client from where the DDL event originated from. Using the service broker's act...
I am in the process of evaluating a Service Broker with SQL noticiation for my project. My requirements is User places a order from System A and it will update Order Table. As soon as order is place i need to notify the System B. I have done a quick POC with Trigger , Service Broker and SQLNotificaiton ADO.NET. It is working as i expecte...
I've implemented a messaging system over SQL Server Service Broker. It is working great, with the sole exception that every once in a while (maybe once per week per server) my initiator service just vanishes without a trace. The corresponding queue is still there, but the service is missing. Obviously this causes problems in my system...
I am getting this error in my sys.transmission_queue table whenever I attempt to send a SQL Service Broker message between two different SQL Server servers. (i.e. the databases are on two different physical machines) Dialog security is unavailable for this conversation because there is no security certificate bound to the database prin...
I am attempting to understand the complete picture of Service Broker external activation. I have found bits and pieces of different aspects, but nothing that is a complete simple sample. Can anyone point me to one? ...