• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 316
  • Last Modified:

Session Browser

Hi,
 There is something called a Session Browser in Oracle,which will have a log of all the sessions logged onto the database.
 Is there anything similar to that in Sybase?If yes,then how to access it?
 Also,is there a way to describe a table structure in Sybase,like "Desc tablename" in Oracle?
0
pvsbandi
Asked:
pvsbandi
  • 2
1 Solution
 
morisceCommented:
to show sessions, execute the system command : sp_who
to describe a table execute : sp_help tablename
0
 
pvsbandiAuthor Commented:
In Oracle,with tool like TOAD,we have an option to access the session browser.Here i see all the sessions.
  If i run a query from say,Business Objects,i can see the SQL that is run,in the session browser.Is there anyway,
  i can access that SQL generated in the Session Browser,in Sybase?
 
0
 
morisceCommented:
with the command sp_monitor you can see all tables used in the server (all sessions) at the execution time of the cmmand (sp_monitor). i don't know a command or a standard sybase tool which whow the sql queries executed by all sessions.

0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now