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
