Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Posts
    144

    Question Unanswered: How can I get the ProcessID of a give stored procedure call?

    Hello!

    How can I get the ID of the process a given stored procedure call belongs to? I want to make some like this:

    create procedure P1

    as

    declare ProcID numeric
    set ProcID=SomeFunction()

    insert into T1 values (ProcID, ....)

    GO

    Thanks a lot.

  2. #2
    Join Date
    Apr 2003
    Location
    Israel
    Posts
    81
    Try @@spid
    --
    kukuk

Posting Permissions

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