Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

SELECT Monitor

2 posts in Windows NT Last posting was on 2000-05-15 18:30:37.0Z
Stefano Opice Posted on 2000-05-11 09:51:15.0Z
From: "Stefano Opice" <stefano.opice@theorematica.it>
Subject: SELECT Monitor
Date: Thu, 11 May 2000 11:51:15 +0200
Lines: 8
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <0Knh88yu$GA.202@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 212.177.108.130
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2180
Article PK: 1089614

I have this problem: I want monitor all the select commands on Adaptive
Server; is there a command or a stored procedure to monitor this command ?

Thanks

Stefano


David Owen Posted on 2000-05-15 18:30:37.0Z
Sender: dowen@kashka.midsomer.org
Subject: Re: SELECT Monitor
References: <0Knh88yu$GA.202@forums.sybase.com>
From: David Owen <dowen@midsomer.org>
Organization: Midsomer Consultants Inc.
Date: 15 May 2000 12:30:37 -0600
Message-ID: <m2wvkvvf76.fsf@kashka.midsomer.org>
Lines: 12
User-Agent: Gnus/5.0802 (Gnus v5.8.2) Emacs/20.5
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: h29-5d-f4-26324826.cg.shawcable.net 24.70.23.180
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2167
Article PK: 1089599

>>>>> "Stefano" == Stefano Opice <stefano.opice@theorematica.it> writes:

Stefano> I have this problem: I want monitor all the select commands on
Stefano> Adaptive Server; is there a command or a stored procedure to
Stefano> monitor this command ?

You need to install and enable auditing. Alternatively, ProActive DBA will
do this for you without having to reconfigure *anything*.

--
David Owen Midsomer Consultants Inc. dowen@midsomer.org
Sybase FAQ: http://www.isug.com/Sybase_FAQ