Back

Determining if you have any modified eConnect pre or post procedures

Published: May 21, 2013
Post Author Written by David Youngquist

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)

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

We're on your integration team. Connect with our people and let us know how we can help you.