[ISSForum] Trouble with ISSED database in MS SQL 2000

[syesilyurt]

Title: Managing sensors from command line

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