variable population using xp_servicecontrol

[johnem]

Dear Listers,

Is there a means by which I can populate a variable using the following
syntax ?

exec [servername].master.dbo.xp_servicecontrol querystate,msdtc

Note the following:

If the source server was 'AA' and my statement was :

insert #temp(columnname) --(on server BB - target server)
exec [AA].master.dbo.xp_servicecontrol querystate,msdtc

the statement fails because the msdtc service is not running on server AA.

What I need is for the return value, 'stopped' to populate a variable,
or
table row on server BB.

If msdtc is running, (on server AA), there is no problem. ie. #temp(columnname) can be populated. (on server BB)

Regards,

John

 

[LogicalmanUS]

Johnem,

As you stated, if the service ois not running on the remote server, then it fails, and that is where you can get your result from.
Immediately after the statement fails, look for the error code (@@ERROR), and code accordingly.

Logicalman