I don't think I have been very clear.

I have an audit table that I want to use in order to monitor when data was last inserted into certain tables. It...

Hi Jeff,

Would the below be a better solution?

CREATE TRIGGER [TriggerName]

ON [InsertDataIntoThisTable]

INSTEAD OF INSERT

AS

BEGIN

DECLARE @Count INT

SELECT @Count = COUNT(*) FROM inserted

END

IF

@Count > 0

UPDATE

[AuditTable]

SET LastUpdated = GETDATE()

WHERE ...

Many thanks

Thanks for the swift response Lowell.

The data is inserted using SSIS packages which state the number of rows that have gone in - thanks for the suggestion though.

Many thanks again.

Thanks for the reply. I am now able to use the Database I wanted.

Many thanks,

Ben B