SQL Profiler

[Carney123]

Is there Equivalent tool in Sybase which does the SQL Server 2000 SQL Profiler does?

 

[PDreyer]

What do you want to achieve? There is montables and auditing.

 

[Carney123]

I want to capture the queries and stored procedures when application is running. In SQL I can run the profile and capture the queries. Same way I want to do it in Sybase.

 

[PDreyer]

For Sybase ASE
if mon tables are installed
select * from monProcessSQLText
select * from monSysSQLText

or
You can enable auditing to capture sql text
See the admin guide regarding auditing

or similar to dbcc inputbuffer on ms sql:
dbcc traceon (3604)
dbcc sqltext(<spid>)