yes, as long as the corresponding data provider supports transactionsseehttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_md_06_8tf7.asp
"...
In general, Microsoft SQL Server requires distributed transactions support from the corresponding OLE DB provider whenever data from more than one linked server are likely to be updated in a transaction. Hence, the types of queries that are supported against linked servers depend on the level of support for transactions present in the OLE DB providers
..."
"...
In general, Microsoft SQL Server requires distributed transactions support from the corresponding OLE DB provider whenever data from more than one linked server are likely to be updated in a transaction. Hence, the types of queries that are supported against linked servers depend on the level of support for transactions present in the OLE DB providers
..."
解决方案 »
- 数据库执行一条语句过程中如果断电会怎样?
- 关于C#+ASP采用三层结果调用存储过程的问题,在线等——————————————急——————————————————————
- (在线等)多个数据库操作问题
- 关于数据库'复制'中,分发服务器该设在哪台机上的问题
- 求一段递归生成目录树的sql
- SQL2000中更新数据为NULL
- 已知表名,如何写SQL语句来判断数据库中是否存在这样的表?
- 模糊查询问题
- 不用存储过程,怎么向数据库中插入二进制文本或者图片。
- 安装sqlserver客户端后,启动出错:管理单元初始化失败 在线等待
- 请问要如何才能把一个非分离出来的MDF文件再附加回数据库去?
- 菜鸟问一个数据表建立问题(工厂管理)?
exec master..xp_cmdshell 'net start msdtc',no_output set XACT_ABORT on
set ANSI_NULL_DFLT_ON on
set ANSI_WARNINGS on BEGIN DISTRIBUTED TRANSACTION
select * from OPENDATASOURCE('MSDASQL','DRIVER={SQL Server};SERVER=ip;UID=sa;PWD=密码;').pubs.dbo.jobs
commit tran
BEGIN DISTRIBUTED TRANSACTION
不是
begin tran