There is another command that you can use: iss_truncateevents this will
clear all the tables and give you a fresh database. You can run this command
under the SQL Query Analyzer in SQL2000.
Regards
Devonne
> -----Original Message-----
> From: Willig, Mike {D106~Indianapolis} [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, January 09, 2003 5:12 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]" <[EMAIL PROTECTED]>
> Subject: RE: [ISSForum] Trouble with ISSED database in MS SQL 2000
>
>
> In the ISSED database, there's a stored procedure called "iss_PurgeEvents"
> that might be a good
> starting place for you. It touches many tables, but in a way that avoids
> the referential integrity issues
> that you're having.
>
> There's an ISS knowledge base article (interestingly it is Answer ID#
> 666) with more information.
> Easiest way to find it is to search on "iss_purgeevents".
>
> Hope this helps.
>
> -Mike
>
>
>
> -----Original Message-----
> From: syesilyurt [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 09, 2003 2:55 AM
> To: [EMAIL PROTECTED]
> Subject: [ISSForum] Trouble with ISSED database in MS SQL 2000
>
>
> Hi,
> I have a problem with ISSED database whose size increases and tables
> cannot be truncated.
> The ISSED database managed by MS SQL Server 2000, saves the logs created
> by the software RealSecure version 7.0.2002.
> Its size has reached up to 10 GB which is near to the disk capacity. I
> want to clean up the rows in the ISSED DB tables but cannot achieve due to
> the referenced tables. There are too many tables and I do not know which
> table to begin truncate without violating the referencing constraints.
> When I truncate tables with the sql command "truncate table table_name;",
> I see an error about violating the referencing constraints.
> What shall I do for cleaning up the ISSED database tables without dropping
> the DB or tables after backup? Is there a script to truncate tables or
> delete rows? Isn't there any way other than dropping database?
> thanks.
>
>
> Selman YESILYURT, IT Security Administrator
> Tel : 90-312-402 2398 ANKARA/TURKEY
>
>
> _______________________________________________
> ISSForum mailing list
> [EMAIL PROTECTED]
>
> TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to
> https://atla-mm1.iss.net/mailman/listinfo
******************************************************************
This communication is intended only for the person to whom it is addressed and may
contain confidential and/or privileged material. Any retransmission, dissemination,
use of, or taking any action in reliance upon, this communication by persons other
than the intended recipient(s) is prohibited and may be unlawful. If you have received
this in error, please notify the sender and delete the material from any computer.
WARNING: whilst we take reasonable precautions to ensure that any attachment has been
swept for viruses, we cannot accept liability for any damage sustained as a result of
software viruses and would advise that you carry out your own virus checks before
opening any attachment.
See our website at http://www.bankofbutterfield.com
_______________________________________________
ISSForum mailing list
[EMAIL PROTECTED]
TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to
https://atla-mm1.iss.net/mailman/listinfo
