having just purchased a new server for an MSSQL 2000 installation i would highly reccomend this configuration. it runs quick as you like.

Compaq proliant ML570 with Quad Xeon III processors.

4GB...

I handle 4 MSSQL 2000 servers, 1 Sybase 12.0 Adaptive server, 1 Oracle 9i server, and some old dodgy Access and Fox Pro applications some monkey knocked out as a...

The position i was in prior to the current one was a 90% production role in a team of 5 production DBA's. Admittedly that was a large company with a...

just checked the DTC and it is running at both ends, any other ideas?

Does seem that way, where would one turn it on?

Thanks for the advice, helped a great deal.

The core of the problem is the sp_script_synctran_commands procedure which is cutting of the end of the input set for the sp_addsynctriggers...

This is somthing i have been trying to stress to the development team i work with for ages. thanks for a well written back-up to my nagging.