database name of current session ?
Hello, How can i find database name of current session using select statement? Thanks
Just look at DBINFO:
database sysmaster;set isolation to dirty read;SELECT odb_dbname[1,18] _, "IS BY DATABASE" _ FROM sysmaster:sysopendb WHERE
odb_sessionid = DBINFO( 'sessionid' ) AND odb_iscurrent = 'Y';select
dbinfo('sessionid') _, "IS MY SESSION" _ from systables where tabid = 1;
-----Ursprüngliche Nachricht-----
Von: "ABRAR RASHID"
Gesendet: Jan 19, 2011 3:13:51 PM
An: ids@iiug.org
Betreff: database name of current session ? [22489]
>Hello,
>
>How can i find database name of current session using select statement?
>
>Thanks
>
>
>*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
___________________________________________________________
Empfehlen Sie WEB.DE DSL Ihren Freunden und Bekannten und wir
belohnen Sie mit bis zu 50,- Euro! https://freundschaftswerbung.web.de
you can use "onstat -g ses "session_id". it will show you all with regards to
that session.