Post reply

Profiler filtering question

  • February 21, 2007 at 5:20 am

    #95164

    So for the first time I try to create a trace with SQL 2005. I wish to check who/what connects to a certain database. I can set this up quiet easily, but I cannot find how to limit events to this specific database. I know how to do this in SQL 2000, but such a dialogbox seems not to exits in SQL 2005.

    Or am I missing something?

    Help?

    Greetz,
    Hans Brouwer

  • February 21, 2007 at 5:24 am

    #690863

    OK, I was too quick to ask this question. Decided to click the show all columns button....

    It seems I can only select DatabaseID now... Obviously it's as good as DatabaseName, however, I know databasenames just like that, I need to look up  ID's...

    Oh well.

    Greetz,
    Hans Brouwer

  • February 21, 2007 at 7:17 am

    #690889

    experience has taught me that the dbid is better than the name in profiler. It's only a quick lookup

    select

    * from sys.databases

    select

    db_id('master')

     

     

     

     

     

     

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

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

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