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 SQL
> 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,
>