Thank you

Gonna try those and see if it suits for these

people over here =)

Thank You!

I'm just doing what these people tell me to do here = )

But we're doing these in couple different ways to know which is the best way

to record things...

Yes, No I mean no to the update statement =)

Yep, that's what I was thinking too about the deleted rows.

There's an error with the post of the table name, it...

ID int IDENTITY(1,1) NOT NULL, <-- primary key

name varchar(100) NULL,

type varchar(2) NULL,

address char(11) NULL,

start_date [int] NULL,

end_date [int] NULL,

modified_date datetime NULL, <-- this is where the insert, update, delete timestamps suppose...

CREATE TRIGGER RecordUpdate

ON Rooms

AFTER INSERT

AS

BEGIN

INSERT INTO DatabaseOperations

VALUES(N'', N'', N'',

N'', GETDATE())

END

GO

this is the thing what i've tried. Got this...