AFAIK unique connection numbers are assigned for all connections to all databases started by one server execution instance, and they can be reused only by a different execution instance. Presumably, they can also be reused if the number wraps. If you're keeping records: For a given database file, CONNECTION_PROPERTY ( 'Number' ) and CONNECTION_PROPERTY ( 'LoginTime' ) suffice to uniquely idenfify a connection. See also: How are connection numbers assigned?
(02 Mar '15, 03:22)
Martin
|
Just to add a quote from the v9.0.1 (and 8.0.3) "What's new" section:
(Internal/temporary connections used by events and the like are treated differently, as you'll know.) For older versions, the behaviour was different, but I don't remember... |