SQL Server doesn't store Modified Date only Create Date. You can add your own triggers to the tables of interest and record updates. Maybe that system has such audit information recorded already?
>Try to set up a program to export SO to Solomon accounting program using SQL tables.
>
>After I have entered a new SO from the Shipper screen in Solomon, I want to know which tables got updated.
>
>But, SQL Enterprise Manager only tells you Create Date, instead of Date modified. How to get the information?
>
--sb--