The only other thing I can think of is if your trigger has been changed.
I have an incident where someone used the SQL Maint Wizard and it adding
some stuff to the trigger, rendering it useless. Once the addition
was removed, it worked again.
> I am using the same Username and password that I use on the other machines
> that work fine.
Are you using domains, or local user names? Are the SQL Servers/Clients
configured for TCP/IP or named pipes?
-- Dale E. Reed Jr. (firstname.lastname@example.org)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.emerald.iea.com