Getting Last Executed SQL Statement from SQL Server

Hi,

can we get the last executed SQL statement (Insert, Update, Delete) from some system table of SQL Server 2000 from a stored procedure ?. This is for logging the activities

Rgds
Anil


Rgds,
Anil