How to find your own session_id when you login to database

#1 (**permalink**) 04-20-2008, 07:53 AM

Hello,
Is there a way for me to find out what is my own session_id (sid) when I am
logging to database?

Thanks in advance for you help.

Thanks,
Thanh Ngo

#2 (**permalink**) 04-20-2008, 07:53 AM

On Wed, 13 Oct 2004 17:13:28 -0400, Thanh Ngo wrote:

select dbinfo('sessionid') from systables where tabid = 1;

Art S. Kagel

> Hello,
> Is there a way for me to find out what is my own session_id (sid) when I am
> logging to database?
>
> Thanks in advance for you help.
>
> Thanks,
> Thanh Ngo

#3 (**permalink**) 04-20-2008, 07:53 AM

Thanks so much. That is what I want.

Thanks,
Thanh Ngo

"Art S. Kagel" wrote:

> On Wed, 13 Oct 2004 17:13:28 -0400, Thanh Ngo wrote:
>
> select dbinfo('sessionid') from systables where tabid = 1;
>
> Art S. Kagel
>
> > Hello,
> > Is there a way for me to find out what is my own session_id (sid) when I am
> > logging to database?
> >
> > Thanks in advance for you help.
> >
> > Thanks,
> > Thanh Ngo

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode