ASE Database forum - Unique identifier for each client database connection

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Unique identifier for each client database connection

Alex Fonseca

2005-10-27, 8:21 am

Does Sybase offer any method for returning a unique identifier for each
client database connection?

Bret Halford

2005-10-27, 8:21 am

sysprocesses.spid is unique at any given point in time. The client
can retrieve this value with "select @@spid".

The combination of sysprocesses.spid and loggedindatetime
would be unique for the server over time.

Alex Fonseca wrote:

> Does Sybase offer any method for returning a unique identifier for each
> client database connection?

Sponsored Links