Some third party applications will use eConnect pre or post procedures that can modify the behavior of the standard Microsoft eConnect procs. Applying a GP service pack will overwrite out any customized pre and post procedures, so it is a good idea to back them up prior to applying a service pack. If you run the following statement in SQL Server Query Analyzer, you can determine if you have any modified procedures.

---

SELECT name, create_date, modify_date
FROM sys.objects
WHERE (type = 'P') AND (name LIKE 'ta%Pre' or name LIKE 'ta%Post') AND (create_date <> modify_date)