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.

How to look at DML statements from sysaudits...

2 posts in Windows NT Last posting was on 2000-01-29 00:25:15.0Z
Raju Posted on 2000-01-28 18:47:33.0Z
Message-ID: <3891E445.5C0B5DE8@keycommerce.com>
Date: Fri, 28 Jan 2000 10:47:33 -0800
From: Raju <b_raju@keycommerce.com>
X-Mailer: Mozilla 4.7 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: How to look at DML statements from sysaudits...
Content-Type: multipart/alternative; boundary="------------98986D8F04917AB20F19B90A"
Newsgroups: sybase.public.sqlserver.nt
Lines: 31
NNTP-Posting-Host: pyrenees.keycommerce.org 63.83.198.254
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2622
Article PK: 1090073

Hi all,
Can some one help me..
It is on Sybase 11.9.2 on WinNT4.0
I have installed Audit database and I have enabled auditing and I have this set for one user. When I look at the sysaudits table, it is not showing me the complete DML statement. It is just showing me like...
SELECT ; ; ; ; ; ; ; ;
..but not the complete statement. How to look st the complete statement!

Thanks,
Raju.


Randy Reiter Posted on 2000-01-29 00:25:15.0Z
Reply-To: "Randy Reiter" <rreiter@sqlpower.com>
From: "Randy Reiter" <rreiter@sqlpower.com>
References: <3891E445.5C0B5DE8@keycommerce.com>
Subject: Re: How to look at DML statements from sysaudits...
Date: Fri, 28 Jan 2000 19:25:15 -0500
Lines: 82
Organization: Sql Power Tools
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_NextPart_000_009A_01BF69C5.678311A0"
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <cGEEn#ea$GA.306@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 153.newark-11-12rs.nj.dial-access.att.net 12.78.100.153
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2617
Article PK: 1090068

Refer to www.sqlpower.com.  The Zero Impact Sql and Service Level Monitor will capture all SQL text and performance with no impact upon the database server, network and end-users.  Scales to thousands of users.  Installation is a few minutes.

Randy Reiter
 
Sql Power Tools
702.990.3209
www.sqlpower.com
Raju <b_raju@keycommerce.com> wrote in message news:3891E445.5C0B5DE8@keycommerce.com...
Hi all,
Can some one help me..
It is on Sybase 11.9.2 on WinNT4.0
I have installed Audit database and I have enabled auditing and I have this set for one user. When I look at the sysaudits table, it is not showing me the complete DML statement. It is just showing me like...
SELECT ; ; ; ; ; ; ; ;
..but not the complete statement. How to look st the complete statement!

Thanks,
Raju.