Results 1 to 2 of 2

Thread: Spid

  1. #1
    Join Date
    Nov 2005
    Posts
    13

    Unanswered: Spid

    HI!
    if i have SPID. then can i get the storedprocedure name ?

    Regards,
    Shabber Abbas Rizvi.

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    Could you please clarify? Are you asking: "If I have the SPID of the user connected to the database, can I find out what stored procedure he is executing?"

    If so, the answer is, take a look at DBCC INPUTBUFFER.

    If you are asking, "If I have the ID [object id] for an object, can I find out what the name of the object is?"

    If so, the answer is, take a look at OBJECT_ID or the sysobjects table.

    Regards,

    hmscott
    Have you hugged your backup today?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •