Write something to the table

[RogerH]

Hi,

that's something the database should do! I have written an update trigger for that on SQL Server 7.0:

CREATE TRIGGER [TableUpdate] ON [tableName] 
FOR UPDATE AS
	UPDATE [TableName] SET 
		Updated = GETDATE(),
		Updated_From = SUSER_SNAME()
		WHERE Number IN 
		(SELECT Number FROM Inserted) and Deleted is Null

Number is the primary key on the table "tableName".

Roger