Thanks, Steve.

I was afraid that was going to be the answer.

Paul

Thomas,

That looks like it is exactly what I'm looking for.

Thank you!!! That's a BIG help!

Paul

Thomas,

My preference is also to use T-SQL.

Thank you for directing me to your script and to the hint about using BULK INSERT. I've not used it before -- this is...

Andy.

The flat file will be updated about once per minute, but we will only bring the data into our SQL table about once a week.

Thanks for the suggestion about DTS....

Thanks, Antares686...

That answered my question. Now I know what I need to do to solve it from here.

I appreciate your help!!!

Paul

Thank you ANTARES686, PINHEAD and NPRATT. With the references and scripts you all offered, I'm well on my way to accomplishing the task. Your help is very much appreciated!

PC:

Thank you! Thank you! THANK YOU!

With just a little tweaking it works just

the way it did in SQL6.5.

Here's how I rewrote it. You can see the

changes were very small.

update...

I agree that the best way would be to have the trigger rollback if change_reason field was not updated, but I was trying to avoid the rollback because ALL data...

Thanks for the input.

What I'm trying to do is force the user to enter a reason why the record was changed. Then I want to copy this reason, along with...

That trigger fires even when the approvedby value is NOT changed. I found a work-around, but would rather fix it right. The work around is to use a second column...

The trace shows a select statement where data is gathered from every column in the table, then an update statement where every column, including the approvedby column, is updated. Therefore,...