Post reply

SQL Server Trace

  • November 1, 2005 at 10:19 am

    #112274

    All,

    I have not used Profiler very much but I am trying to trace the activity of a specific database by using the Database name Like 'dbname' in the Filter Tab but when I run the trace it shows activity on other databases.

    Am I doing something wrong?

    Any help would be appreciated.

    Regards

    Carl

  • November 1, 2005 at 10:22 am

    #601612

    filter on dbid

     

    USE master

    SELECT name, DB_ID(name) AS DB_ID

    FROM sysdatabases

    ORDER BY dbid

  • November 1, 2005 at 10:29 am

    #601614

    That was going to be my next test.

     

    Thanks

     

    Carl

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

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