Post reply

SQLProfilerSP_Counts data

  • 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.

     

     

  • 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.

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

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