You can if you start the Profiler tool (in Enterprise Manager click on the tools menu option and select Profiler). This monitors what is going on in SQL server, but it can affect performance. There is no other way I know of to get a log of what is happening.
Regards
Peter