just a comment, in the syscolumns table there's another way to get the names and easier for me to remember

instead of querying the table as you do, you could also...

for what you posted is seems that you have an error in the sql statement... is all i can think of from reading your post

why don't you post the query,...

thanks for your reply, but i already know how to do that, but loggin the updated/deleted data is of no use for me, as i need to know who and how...