• The Standard Template should get you what you want. Although it is better practice to use a server-side trace for performance purposes.

    Which is pretty easy to setup. Quick step is to:

    1) Open Profiler

    2) Select Standard Template

    3) Click Run

    4) Immediately Click Stop

    5) File > Export > Script Trace Definition > SQL Server 2005...

    Save the file and then you can open it up and take out the eventClass(s) that you don't care about. Check here for a list of those: http://msdn.microsoft.com/en-us/library/ms175481(SQL.90).aspx

    This is a good SQL Tip to creating the trace as well: http://www.mssqltips.com/tip.asp?tip=1035

    Shawn Melton
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton