文件名称：Service Broker 源码 示例
文件大小：10KB
文件格式：ZIP
更新时间：2012-07-08 02:25:28
Service Broker 源码 示例
在同一台服务器上，两个不同的数据库实例互发消息的例子 ================================== SQL Server 2005, Service Broker Sample ================================== The example illustrates communication between two different database instances on the same Server 1. Run the script setupdb1 2. Run the script setupdb2 3. Run the script SendScript 4. now view the t_log table in the first database, and second database The scripts create all required service broker items, as well as stored procedure for listening to received messages. The Sendscript, sends a message from localsb_db1 (database) to localsb_db2 database
【文件预览】：
localServiceBroker
----localServiceBroker.ssmssln(362B)
----localServiceBroker.sqlsuo(31KB)
----localServiceBroker()
--------SetupDB2.sql(7KB)
--------HelperFunc.sql(458B)
--------SetupDB1.sql(7KB)
--------SendScript.sql(1KB)
--------SQLQuery2.sql(2B)
--------localServiceBroker.ssmssqlproj(2KB)
----readme.txt(586B)