==================================
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
没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
在同一台服务器上,两个不同的数据库实例互发消息的例子 ================================== 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.zip (9个子文件)
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
共 9 条
- 1
资源评论
- 维纳斯的眼泪2012-10-19没能实现想要的功能,不过谢谢分享了
FrieWolf
- 粉丝: 1
- 资源: 8
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功