关于msdtc服务的问题？？

[lanfanghelanfanghe]

我调用如下触发器
create TRIGGER PDM_itemmaster_uf ON [dbo].[PPP_itemmaster]
FOR INSERT,update,delete
AS
set @tb='a.dbo.Inventory'

declare @rm_tb varchar(2000)
set @rm_tb = 'OPENROWSET(''SQLOLEDB'', ''DRIVER={SQL Server};SERVER=cwserver;UID=sa;PWD='', '+@tb+')'

select ITEM_CODE,ITEM_NAME into #i from inserted
select ITEM_CODE,ITEM_NAME into #d from deleted
exec('delete from '+@rm_tb+' where exists(select * from #d where ITEM_CODE='+@rm_tb+'.CinvCode)')
exec('insert into '+@rm_tb+'(CinvCode,cInvName) select * from #i')

GO

说没有开msdtc服务，请问如何开该服务，上面程序如何能好使，十万火急！！！！

[yydy]

net start msdtc

[了缘]

UP

[lanfanghelanfanghe]

又出现了下面毛病

说OPENROWSET附近有语法错误

[lanfanghelanfanghe]

帮帮忙

[lanfanghelanfanghe]

无法为 OLE DB 提供程序 'SQLOLEDB' 启动嵌套事务。之所以需要嵌套事务是因为 XACT_ABORT 选项已设置为 OFF。
[OLE/DB provider returned message: 无法在此会话中启动更多的事务。]

出现上面错误，请问如何解决！！1

[yydy]

SELECT a.*
FROM OPENROWSET('SQLOLEDB','seattle1';'sa';'MyPass',
'SELECT * FROM pubs.dbo.authors ORDER BY au_lname, au_fname')

检查单引号，格式？

[luyongning]

对于：
无法为 OLE DB 提供程序 'SQLOLEDB' 启动嵌套事务。之所以需要嵌套事务是因为 XACT_ABORT 选项已设置为 OFF。
[OLE/DB provider returned message: 无法在此会话中启动更多的事务。]

出现上面错误，请问如何解决！！1

错误提示已经说明了是因为 XACT_ABORT 这个参数为OFF，所以要把它打开就可以了。
解决办法：
create TRIGGER PDM_itemmaster_uf ON [dbo].[PPP_itemmaster]
FOR INSERT,update,delete
AS
set XACT_ABORT on
set @tb='a.dbo.Inventory'

declare @rm_tb varchar(2000)
set @rm_tb = 'OPENROWSET(''SQLOLEDB'', ''DRIVER={SQL Server};SERVER=cwserver;UID=sa;PWD='', '+@tb+')'

select ITEM_CODE,ITEM_NAME into #i from inserted
select ITEM_CODE,ITEM_NAME into #d from deleted
exec('delete from '+@rm_tb+' where exists(select * from #d where ITEM_CODE='+@rm_tb+'.CinvCode)')
exec('insert into '+@rm_tb+'(CinvCode,cInvName) select * from #i')

set XACT_ABORT off

GO