SQLProfilerSP_Counts data

• rs

  SSCrazy

  Points: 2819

  More actions

  February 21, 2007 at 9:06 pm

  #75130

  I ran the profiler for 7 hours (template SQLProfilerSP_Counts) , how can get the information about DatabaseID,ObjectID,SPID?

  I mean which database (databaseID) , sp name (ObjectID) ...

  Thanks in advance.

  SR.

   

   

• happycat59

  One Orange Chip

  Points: 29389

  More actions

  February 21, 2007 at 9:21 pm

  #691065

  You can use the DB_NAME() function to get the database name

  e.g. Select db_name(11)

  The object id is specific to the database that the object is in (and the same object may have a different name if it exists in two different databases.

  To get the object name, connect to the database (probably using the name returned by db_name() )

  and then use the object_name() function.