Hostname as filter at profiler 2005

How is possible to set hostname for sql profiler filtering? It is possible with sql profiler 2000.

thanks,
Bojan

This is a common problem. I'll write a blog post about it.

In SQL Server 2005, Profiler hides columns by default. Columns such as Hostname and DatabaseID are not shown. You need to do the following to be able to filter on these columns:

1) Open SQL Server Profiler
2) Start a New Trace...
3) Connect to your server
4) Go to the "Events Selection" tab
5) Check the "Show all columns" box <-- this is important!
6) Click "Column filters"

Now you'll see Hostname as a property on which you can filter.

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

|||

Thank you!

Bojan