There is a problem with upgrades of CRM 3.0 to 4.0 in that a trigger should have been deleted.
This article has the details: http://support.microsoft.com/kb/948172
I'm on Linkedin, view my profile at http://www.linkedin.com/profile/view?id=26586935
I'm on Twitter, view my profile at https://twitter.com/fkcrm
I'm on Experts Exchange where I answer questions on Microsoft Dynamics CRM. View my profile at http://www.experts-exchange.com/M_4896612.html
I contribute at the MSDN Dynamics CRM forums at http://social.microsoft.com/Forums/en-US/category/dynamics