You can run profiler and filter by the hostname or machine name.
Andrew J. Kelly
SQL Server MVP
"Raymond Du" <rdrd> wrote in message
> I have a website that has about 200 ASPs, a lot of these ASPs send SQL
> statements to a SQL 2000 sever for execution, is there a way to tracetable,> ASP is issuing which statements?
> I would like to know if it's possible to trace from SQL server side. Of
> course I can modify all ASPs to insert SQL statements executed into a> but that's not the answer I am looking for.
> Thanks in advance