Its very simple use the stored procedure
"iss_truncateevents" without any arguments by
selecting the ISSED database. But be cautious to stop
the issdaemon before executing this query or else ur
database may get corrupted.
--- "Willig, Mike {D106~Indianapolis}"
<[EMAIL PROTECTED]> wrote:
>
> 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
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
_______________________________________________
ISSForum mailing list
[EMAIL PROTECTED]
TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to
https://atla-mm1.iss.net/mailman/listinfo
