Is there any way to filter a SQL Profiler trace by dbid This was a feature of earlier versions, but I can't figure it out in 2005.
Thanks!
How to filter Profiler trace by dbid in 2005?
Hot Topic
- How to pick up the last value within a time dimension member
- Accessing the Current Transaction in BOL (April 05')
- CLR Stored Procedure craps out - Msg 6532, Level 16, State 49
- Max with Datepart
- Error executing Parse in SSMS
- RS2005 and SQL2000
- HTTP 500 error accessing Reporting Services..
- Difference between Partial Backup (SQL 2005) and File Group Backup
- How to handle null value?
- ADOX problem...?
SQL Server
- SSIS package
- Join in an update statement
- Data Flow Task & Exception Join
- Execute Package Task: setting child variables
- Has anyone seen a Licensing screen during the install process?
- Can't access analysis cube from other machines
- Can you create folders under Databases in SMS
- Upgrade from MSDE 2000 Release A to SQL Server 2005 Express
- Currency Conversions
- How do set send mail task?
How to filter Profiler trace by dbid in 2005?
lachlanj
Hi there.
From the Profiler GUI, create a new trace, move to the Events Selection tab, click the Show all Columns check box (this is important, as the filters box will only show columns that are selected in the interface), then click the Column Filters button in the lower right corner of the box, you should see the DatabaseID option about 1/3 of the way down the list box on the left...click it, then set the appropriate value in the text box in the lower right of the screen...
HTH,
Musafir
Aha! This is one of those 2 step processes. Thanks a lot!
user11
Yep... it's a little tricky because it's not shown by default.
Steps:
1) Create a new trace.
2) Click the Events Selection tab.
3) Check the box Show All Columns.
4) Click the Column Filters... button.
5) Choose DatabaseID from the listbox on the left.
Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/