Search results for query: *

I checked the event logs, but didn't find anything of use so I did a reinstall of MSDTC: - Disabled the IIS service - Booted the server - Reinstalled MSDTC using C:\Winnt\System32\Dtcsetup.exe - Enabled the IIS service - Booted the server Everything looks normal again. Thanks for all of your...

The script was run from a client using the SA account. I have rebooted the client but this did not appear to have any effect. MSDTC shows no status light (red, green or yellow) in the Service Manager - it simply states that it is in an indeterminate state. The error log shows it is...

I believe the problem lies with the DTC service, but I can't get it out of the "indeterminate state" it's in. The locks which are displayed (through Server-->Current Activity-->Object Locks tab) are associated with tempdb and master database objects. I understand that they shouldn't...

No - the script was loaded into the SQL Query Tool from file and run from there. The MSDTC service is in an indeterminate state (currently not displaying on the services list) and can neither be stopped nor started through SQL Service Manager.

Sorry Terry, I should be more clear...I have rebooted the server several times, but the locks remain. SA owns the process that is causing the locks, but cannot use the KILL command to kill itself, so I need a way around this to terminate the process causing the locks.

Database lock caused by a script that was run from the SA account has resulted in a process which can't be stopped using the KILL command. Reboot does nothing. MSDTC is in an indeterminate state. Any suggestions appreciated.