Posted by dba on 08/20/07 14:53

On Aug 20, 3:28 pm, wesleym...@gmail.com wrote:
> Hi,
> What is the SPID column for in SQL Profiler?
> I have many databases but I only want to view the transactions on one
> particular database. What changes should I make to the filters inorder
> to achieve this. I have tried database name but that doesnt work.
>
> Thanks in advance
> Wes

Hi Wes,

If for some reason the DatabaseName filter doesn't work, you can try
to filter by DatabaseID instead. To get the ID of your database, run
select db_id() against the database.

I also suggest you try out the tool SQL Trace Analyzer. It allows you
to filter your trace with very high granularity and provides detailed
information about your trace that's easy to understand. You can
download it from here: http://www.lakesidesql.com/tadownload/traceanalyzersignup/trace_analyzer_signup.aspx.

HTH

[Back to original message]