MSDTC

Is there a quick way to test if MSDTC is working as it suppose to on my SQL
server?
Thanks,Hi
"msnews.microsoft.com" wrote:

> Is there a quick way to test if MSDTC is working as it suppose to on my SQ
L
> server?
> Thanks,
>
DTCPing can be used to check out MSDTC connectivity issues
http://support.microsoft.com/kb/918331 such as firewall problems
http://support.microsoft.com/kb/306843 There is also the DTCTester tool
http://support.microsoft.com/kb/293799
John|||Set up linked server. Then do this:
BEGIN DISTRIBUTED TRAN
update linkedserver.pubs.dbo.employee
set lname = 'Accorti'
where emp_id = 'PMA42628M'
COMMIT TRAN
Repeat in the other direction too.
If you don't have pubs, install it from script from MS, or use some other
suitable db you have.
TheSQLGuru
President
Indicium Resources, Inc.
<msnews.microsoft.com> wrote in message
news:e8XgUKtqHHA.500@.TK2MSFTNGP02.phx.gbl...
> Is there a quick way to test if MSDTC is working as it suppose to on my
> SQL server?
> Thanks,
>