SQL PROFILER - Database Name does not show up

• Juanita

  SSCertifiable

  Points: 5300

  March 16, 2004 at 3:57 pm

  #178715

  HI. I am running sql profiler and one of my datacolumns is the 'database name'. I cannot get the database name to show up. It will show the databaseid but no name. I do not have any filters that would prevent that. I just tried using the standard default trace and added 'DATABASE NAME' and no luck. I even started sql query analyzer and ran a SELECT statement so i knew forsure i was using a database to capture and no database name comes out in the profiler screen. Is there something that I should be doing special in profiler? Or does your code have to be written in a certain way so profiler can capture the DATABASE NAME?

  THANKS,

  Juanita

   

    

• Prasad Bhogadi

  SSCrazy Eights

  Points: 9235

  March 20, 2004 at 8:08 am

  #499649

  I believe Database Name  shows up only when you run Security Events, otherwise only Database ID is shown. I don't think there are any setting governing this behavior.

  Thanks

   

  Prasad Bhogadi
  www.inforaise.com

• emailmemadhavi

  Newbie

  Points: 9

  January 30, 2019 at 6:03 am

  #2020549

  You need to select Show all columns check box