Hi,

I have a vb.net that statrs a store procedure in sql server 2000.
The store proc run and a new spid is created; the spid can retrieved with @@spid.
But when the vb.net app connect to db another spid is created. How can I retrived this one?
I would like to know how it is possible to retrieve the spid when the vb.net access the database. For istance form vb.net code.

Thank in advance