Lowell:

I changed the names of the colums in the AppointmentStatusTransactions table so they aren't identical to the column names in the Appointment table and voila, it worked.

Not sure if SQL...

Lowell:

You're probably ready to shoot me, but one last thing.

I deleted all the rows from the AppointmentTransactionTable and used the application to update the Appointment table.

The trigger worked perfectly.

Could my...

Lowell:

Once again Thanks.

Couple of clarifications:

1) I'm writing some adjunct code to an application that exists. That's the reason for UNIQUEIDENTIFIERS (I'm stuck with them).

2) The Appointment table...

Lowell:

Tried your suggestion of GROUP & ORDER, still no changes.

Here are the tables (I used SS Mgmt Studio to create:

CREATE TABLE dbo.AppointmentStatusTransactions (

AppoiintmentUID UNIQUEIDENTIFIER PRIMARY KEY,

AppointmentStatusUID...

Lowell:

Thanks for the quick reply.

The data is changing, I've looked at the Appointment table and see that the changes are made, but not reflected in either the INSERTED or DELETED...

Gail:

Thanks for your quick response.

The refresh didn't work, but after your post I decided to shut SS Mgmt Studio down and bring it up again and voila the trigger appeared.

Thanks...