January 27, 2005 at 10:02 am
I need a way to identify a "connection" in an Extended Stored Procedure. Something along the lines of the SPId in Query Analyzer. I need to maintain "connection" specific resources across calls to my ESP. If the user disconnects or closes the connection I need a way to identify those resources for cleanup.
I've tried using srv_pfield(...); none of its responses seem usable. The response to SRV_SPID is actuall the KPID which has a nasty habit of changing periodically
Is there some other way I could do this, maybe use the SRV_PROC pointer to retrieve something?
January 27, 2005 at 11:33 am
Doh!
It would appear that I can use the value of the SRV_PROC pointer as it represents the connection
Thanks, you guys are great! And nobody flamed me for being an idiot
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply