Post reply

Profiler capturing info for a specific db does not work.

  • September 15, 2006 at 12:19 pm

    #61823

    When using Profiler I am attempting to capture activity for ONLY one db on a SQL Server 2000 SP3 it appears to disregard the Filters, database, like parameter.  Has anyone else seen this issue ?  I know if I do the same to only trap activity for a specific SQL Server Auth ID it works as it should.

  • September 16, 2006 at 8:18 pm

    #660907

    run sp_helpdb

    see DB_id for the Database

    and use in filter for DB_id of sql profiler

    instead of Databasename - it is well known  feature

  • September 18, 2006 at 12:56 pm

    #661116

    Awesome ! Thanks, don't know why I did not think to try that... That is what these forums are good for !

Viewing 3 posts - 1 through 2 (of 2 total)

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