i've been using profiler to audit commands issued to our db server.  i
was just wondering if there is an option to filter the said logs for
commands issued by a particular workstation.

thanks!

In Trace Properties do this:

1) On the Data Columns tab add the 'HostName' column;

2) On the Filters tab apply the 'HostName' filter.

If you don't know the name of the workstation run this query on the client
(the workstation):

select host_name


ML

thanks!


*** Sent via Developersdex http://www.developersdex.com ***

How Do I Avoid Update Deadlock
ordered insert - select is not inserting in order
Delete Without Writing To Transaction Log
clustered index on a identity field
ROWS with null values getting truncated.