Post reply

All sql run by a certien proccess

  • June 23, 2004 at 10:02 am

    #108409

    Is there a way I can see all SQL statments run by a proccess since it logged on to the SQL server?

    (I know.....sorry I`m a noob )

  • June 24, 2004 at 6:19 am

    #511756

    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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply