very cool thank you to everyone for there help, I am very much a novice at this stuff so will take me a while to figure some of this stuff...

where could i find this tracker?

is that a default stored procedure in sql 2000?

This is my Table

SELECT [TcaPKey]

,[AgrPKey]

,[AloPKey]

,[TcaCustomerName]

,[TcaContactName]

...

Just googled SSMS, and yes i am using that.

Whats a good way or format to give you the schema in? Also not sure what you mean by SSMS?

Everything works great the only issue I seem to have is if I do a manual change to the table, I get an error.

(The Row value(s) updated or deleted either...

Thank you, I'm testing it now.

--===== If the test table already exists, drop it

IF OBJECT_ID('TempDB..#mytable','U') IS NOT NULL

DROP TABLE #mytable

--===== Create the...

Is there a way to do this to a specific record when a portion of that record changes? I keep getting errors when I try the above solutions cause I'm...

awesome I will give that a try, that looks close to what i'm looking for..thanks a bunch

Currently we are using SQL Server Enterprise manager to write most of queries. Thanks for you help!

thank you will try that, appreciate all your help

BOL? Sorry pretty new to this stuff.

Thanks for your help