Is there a way to track update or insert queries in sql database

[jadoogar]

I have an exam related database which is opereated thru
front end VB for data entry. However knowing a database user password somebody can unauthorisedly manipulate data.
I am using SQL sever 7.0
Is there any way to track the activities of such a user
and store the update/insert commands done by him and time
recorded so that we may check it periodically for any
unauthorised data manipulation.

The activities may be recording it in transaction log but
how do we get a clue about it from going thru log
Someone please help. in SQL Server 2000 we can have the list
of ongoing transations viewed , but what about sql server 7.0
Someone pls advice

 

[nigelrivett]

You can use the profiler to log all operations.
You can create audit trail triggers - see

http://www.nigelrivett.net/Triggers_2_Creating_Audit_Trails.html

You can get the log explorer from lumigent.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[jadoogar]

Thank u very much for this great help