Do I have to modify this trigger to work with my database? When I try to run the trigger in SQL2000 it blows syntax errors? Can anyone help?

Sorry I am new to the database world:hehe:

This is my errors.

Server: Msg 156, Level 15, State 1, Procedure Audit, Line 1

Incorrect syntax near the keyword 'DATABASE'.

Server: Msg 195, Level 15, State 1, Procedure Audit, Line 10

'EVENTDATA' is not a recognized function name.

Server: Msg 170, Level 15, State 1, Procedure Audit, Line 11

Line 11: Incorrect syntax near '.'.

Server: Msg 170, Level 15, State 1, Procedure Audit, Line 13

Line 13: Incorrect syntax near '.'.

Server: Msg 170, Level 15, State 1, Procedure Audit, Line 14

Line 14: Incorrect syntax near '.'.

Server: Msg 170, Level 15, State 1, Procedure Audit, Line 15

Line 15: Incorrect syntax near '.'.