Post reply

Getting database accessed from profiler

  • January 24, 2007 at 6:54 am

    #171994

    Does anyone know how I track database access in Profiler so it shows the database being accessed. I tried Database name and ID with no avail.

     

    Thanks

  • January 24, 2007 at 6:59 am

    #685183

    You can filter your results by DatabaseID or DatabaseName.

    I prefer filtering by DatabaseID (DatabaseID equals <YourDatabaseID> rather than DatabaseName since I have noticed that sometimes SQL Server doesn't filter by DatabaseName properly.

  • January 24, 2007 at 7:02 am

    #685184

    How do I equate the database ID to a database? That is what I am trying to figure out. Thanks

  • January 24, 2007 at 7:52 am

    #685220

    USE master

    GO

    SELECT DB_ID(MyDB)

    John

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

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