远程调用存储过程问题

[cattydid]

请大虾帮忙看此段存储过程代码,看有什么问题,为什么一执行(在Query Analyzer里)会半天没反映?

CREATE PROCEDURE sp_sync
AS

declare @cid nchar(10)

if exists (select 1 from master..sysservers where srvname = 'BSERVER')
exec sp_dropserver 'BSERVER','droplogins'

exec sp_addlinkedserver 'BSERVER','','SQLOLEDB','BServer'
exec sp_addlinkedsrvlogin 'BSERVER','false',null,'sa',''
exec sp_serveroption 'BSERVER','rpc out','true'

set XACT_ABORT on
exec master..xp_cmdshell 'isql /S BSERVER /U sa /P /q "exec master..xp_cmdshell ''net start msdtc'',no_output"',no_output

exec master..xp_cmdshell 'net start msdtc', NO_OUTPUT


BEGIN DISTRIBUTED TRANSACTION
select @cid = CID from TTestTable
exec BSERVER.test..sp_del_TTestTable @cid
COMMIT TRAN
GO

[631799]

alter PROCEDURE sp_sync
AS

declare @cid nchar(10)

if exists (select 1 from master..sysservers where srvname = 'BSERVER')
exec sp_dropserver 'BSERVER','droplogins'

exec sp_addlinkedserver 'BSERVER','','SQLOLEDB','BServer'
exec sp_addlinkedsrvlogin 'BSERVER','false',null,'sa',''
exec sp_serveroption 'BSERVER','rpc out','true'

set XACT_ABORT on
--exec master..xp_cmdshell 'isql /S BSERVER /U sa /P /q "exec master..xp_cmdshell ''net start msdtc'',no_output"',no_output
exec master..xp_cmdshell 'isql /S BSERVER /U sa /P /q '

exec master..xp_cmdshell 'net start msdtc', NO_OUTPUT


BEGIN DISTRIBUTED TRANSACTION
select @cid = CID from TTestTable
exec BSERVER.test..sp_del_TTestTable @cid
COMMIT TRAN
GO

[cattydid]

i try it you mentioned, but problem is still the same:(