Tuesday, February 5, 2008

Using filter on SQL Server 2005 profiler

When I first used SQL Server 2005 Profiler to trace the actual sql statement generated from Axapta, I was wonder where I could filter the result based on database name as it is in SQL Server 2000.

This question is answered easily. There is a tick box 'show all columns' in the event selection tab. After this selected, then there are more columns available on the button Columns Filters.