Post reply

using a trace to capture activity done through ssms -- what is the filter for 'application'?

  • February 8, 2012 at 12:00 pm

    #268059

    I would like to trace some events on a server, but I want to limit those to events that I perform via ssms.

    I cannot recall the 'Application Name' for ssms that I would filter by in the trace. Can anyone help? thx. D Lewis

  • February 8, 2012 at 12:17 pm

    #1444714

    Filter on Application Name with "Microsoft SQL Server Management Studio"

    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

  • February 8, 2012 at 12:44 pm

    #1444730

    Bru Medishetty (2/8/2012)

    Filter on Application Name with "Microsoft SQL Server Management Studio"

    I tried this (see attached snip) and no events were captured...

  • February 8, 2012 at 1:34 pm

    #1444765

    Then you can try this, run a trace without filtering the application name and run a simple top x query from SSMS. Stop the trace, it should have captured that row. Look for that line which you ran the top x query and see what is under the application name. Now fire a trace by filtering that...

    Before suggesting you I did that at my end and got what you wanted...

    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

  • February 8, 2012 at 3:06 pm

    #1444814

    You can also change the application name in SSMS connection settings.

    -- Gianluca Sartori

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply