FAQ Database Discussion Community


SignalR Service Broker with data from SQL View, does it work? MVC 5 ASP.NET

sql,asp.net-mvc,signalr,service-broker
I've used SignalR with some Databases in SQL in my MVC 5 web application to update the Webpage when table data is modified. My question is... Can I use a MessagesRepository that uses a SqlCommand to a SQL View? Does a SQL View fire a Service Broker event? I'm very...

After Adding a Contract to a Service in Service Broker

sql-server,sql-server-2012,service-broker
We have a working (mostly) Service Broker setup. One problem is that we forgot to add a message type (EndTransmission) to the contract so I created a new contract and added it to the two services. CREATE CONTRACT [http://bob.us/Locations/Contracts/VolatileData3] ([http://bob.us/Locations/MessageTypes/Resource/EndTransmission] SENT BY ANY) ALTER SERVICE [//Locations/Here/Send/VolatileDataReceiveService] (ADD CONTRACT [http://bob.us/Locations/Contracts/VolatileData3]) ;...

SQL Service Broker - communication scenario - migration from SQL 2008 R2 to SQL 2014

sql-server,sql-server-2008-r2,sql-server-2014,service-broker
Summary: Is there anything new in MS SQL 2014 (versus 2008 R2) that does not allow the following scenario? Can the same approach be transfered to the new server? The application uses SQL Service Broker to collect data from satellite SQL Express machines (technology computers, now two, soon 4, and...

SQL Message Broker leaving messages in Sending Queue

sql-server,sql-server-2008,service-broker
We're putting messages into a SQL Server message queue, by a trigger on a table. (When a field is updated, we build some XML, and call the trigger below). CREATE PROCEDURE [dbo].[up_CarePay_BrokerSendXml] -- Add the parameters for the stored procedure here @Data VARCHAR(MAX) AS BEGIN DECLARE @InitDlgHandle UNIQUEIDENTIFIER DECLARE @RequestMessage...