InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 21:12:45 GMT20http://www.sqlservercentral.com/Forums/Topic492713-146-1.aspxCreate New TraceIn Event Selection Tab, un-check others than RPC:CompletedClick on Column Filters, Click Application Name like ".Net SqlClient Data Provider"Click on [b]Client Process Id=<your host_process_id>[/b](host_process_id=select host_process_id from sys.dm_exec_sessions)Click OK and Run the trace.You will get only traces for for your client and also .net SQL client, not others like Report Server, etc.Mon, 01 Oct 2012 03:13:19 GMTyogeshnelwadkarhttp://www.sqlservercentral.com/Forums/Topic492713-146-1.aspxThanks everybody ..It worked . It will really help me..:)Thanks once again..Mon, 05 May 2008 06:22:23 GMTBhaskar Basakhttp://www.sqlservercentral.com/Forums/Topic492713-146-1.aspxThat is correct, if the connection is through the application server's DAL, then it will be difficult.Wed, 30 Apr 2008 06:09:01 GMTChandrachurh Ghoshhttp://www.sqlservercentral.com/Forums/Topic492713-146-1.aspxIt depends on how the application is set up... HostName might only show the application server that is hitting sql server. SopheapWed, 30 Apr 2008 06:02:48 GMTSopheap Suyhttp://www.sqlservercentral.com/Forums/Topic492713-146-1.aspxIn the Events Selection tab, check the [b]Show all Columns[/b] check box, and then click on [b]Column Filters[/b] button. Select the HostName option from the Edit Filter list on the left frame, and specify the name of the system in the [b]Like[/b] on the right frame.Hope this helps.....Wed, 30 Apr 2008 05:15:31 GMTChandrachurh Ghoshhttp://www.sqlservercentral.com/Forums/Topic492713-146-1.aspxI think there's a column called HostName that you can filter on.JohnWed, 30 Apr 2008 02:42:55 GMTJohn Mitchell-245523http://www.sqlservercentral.com/Forums/Topic492713-146-1.aspxHi AllI want to filter a trace of SQL Server 2005 Profile with the IP address of the client system . [b]Current Situation[u][/u][/b]Multiple workstation is running same application with a common SQL Server login to a common SQL Server 2005[b]Requirement[u][/u][/b]I want to filter the trace for a particular work station when all other users are working.[b]Problem[u][/u][/b]Can anyone suggest me which filter option I need to choose ? Can I use some IP based filter ?Thanks in advance..Wed, 30 Apr 2008 02:21:43 GMTBhaskar Basak