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:
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
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
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.(
Is it possible to use external activation on sql express without going thru sql开发者_JAVA百科 enterprise/standard?
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
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:
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
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
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
加载中,请稍侯......