Listing 1: Code to Retrieve ID Numbers to Use for Filtering
-- Get the database ID number for your database.
-- Use this number to filter in Profiler.
SELECT dbid FROM master..sysdatabases
WHERE [name] = N'Northwind'
-- Get the object ID for the base table or view that you're interested in.
-- Use this number to filter in Profiler.
SELECT object_id('dbo.employees')
-- Get your SPID.
-- Use this number to filter in Profiler.
SELECT @@SPID