Post reply

Determine SPID

  • July 16, 2003 at 12:03 pm

    #82099

    I call a stored procedure. While the stored procedure is still running, how can I determine the SPID for that process (that is running the stored procedure I just called)?

    Thanks.

  • July 16, 2003 at 12:16 pm

    #465719

    Open Enterprise Manager and open the appropriate Database. Go to Management and under Current Activity you can view the current Process ID's.

    All the best,

    Dale


    All the best,

    Dale

    Author: An Introduction to SQL Server 2005 Management Studio

  • July 16, 2003 at 12:16 pm

    #465717

    dbcc opentran

  • July 16, 2003 at 12:42 pm

    #465727

    Thanks for prompt responding.

    I should have been more specific on this. What I wanted to do is to find out the SPID from the Client side which is written in VB using ADO.

    I call the stored procedure from VB. I have the Stored Procedure's name. How can I find out it's SPID without going to Enterprise Manager or Query Analyzer? Thanks again.

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

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