service-broker
Receive Service Broker from a CLR stored procedure
I\'m trying to move this T-SQL stored procedure to a CLR procedure, but there\'s a Service Broker specific command that I don\'t know how to implement:[详细]
2023-01-20 20:39 分类:问答Single conversation in Service Broker
I\'m going to do async auditing on my SQL Server 2008 as shown here: http://auoracle.blogspot.com/2010/02/service-broker-master-audit-database.html[详细]
2023-01-20 09:47 分类:问答Using SQLDependency/SqlNotificationRequest to have multiple instances of the same app receive the same notifications?
I started looking at this recently with the very limited knowledge that the ASP.NET Cache could somehow make use of a SqlCacheDependency to invalidate the cache when a table (ora queries results) chan[详细]
2023-01-16 15:39 分类:问答Can I ensure the order of dialog conversations in sql service broker?
So, I\'ve got an \'A\' server and a \'B\' server.We are using SQL Service Broker to perform replication.An application we have will need to write data to either the \'A\' server, or the \'B\' server.([详细]
2023-01-14 01:24 分类:问答Using Service Broker with Sql Server Express 2008
Is it possible to use external activation on sql express without going thru sql开发者_JAVA百科 enterprise/standard?[详细]
2023-01-13 11:07 分类:问答Service Broker : Sys.Conversation_endpoints filling up with CO/CONVERSING messages when using With Cleanup
We recently identified a problem with one of our databases where as a result of a \'fire & forget\' setup (i.e: conversations being closed immediately after sending), our sys.conversation_endpoint[详细]
2023-01-11 10:37 分类:问答How can I check in c# if Broker Service is enabled in SQL?
I wa开发者_开发知识库nt to check if Broker Service is running using code and depending on the status, start sqldependency or not. How can I do that?You can do a simple query:[详细]
2023-01-11 02:08 分类:问答Service Broker Design
I’m looking to introduce SS Service Broker, I have a remote orders database and a local processing database, all activity on the processing database has to happen in sequence, this seems a perfect j[详细]
2023-01-10 02:41 分类:问答Service Broker getting Automatically Disabled
As we know the Service Broker is enabled for the new databases we create. But recently the service broker 开发者_高级运维got disabled automatically. Even if the database was restored shouldnt the Serv[详细]
2023-01-08 22:27 分类:问答The future of SQLServer Service Broker
is there any information on the future of the Service Broker infrastructure in SQLServer? The team\'s blog (Link) is not very active and there were only minor changes in SQL 2008 R2 release. When buil[详细]
2023-01-02 19:32 分类:问答