Devart Forums

Is it possible to retrieve the @@spid of the current connection of TSQLConnection?

My issue is this,
when I connect the database on my app for the first time I execute, on the event AfterConnect, SELECT @@spid to store the spid,
but if my network broke e gets online again after a few moments, the connection is reestablished, but with new @@spid, and the event AfterConnect is not triggered.

Hi Ron,
Thanks for your request!

Please note, that the AfterConnect occasion is generated by the TSQLConnection component, not by our driver.
We cannot affect the TSQLConnection component.

Also, could you please describe in more details how you restore the connection?

Feel free to ask if you have any questions!