Re: [ISSForum] Trouble with ISSED database in MS SQL 2000

[Simpalean Andrei]

Title: Managing sensors from command line

I thing you need more space. If you use Microsoft Win2000 you can compress the ISSED file using "Properties/Advanced/Compress contents to save disk space" first. Normally this reduces the space used by 1/2. After that, use the standard methods that will work. This method work’s for me.   Andrei SIMPALEAN IT Manager   BEST INTERNET SECURITY Bd. Theodor Pallady 26, Sector 3, Bucuresti Tel.:         004 021 345 5505/ 06/ 07 Fax :        004 021 345 5508 E-mail:     [EMAIL PROTECTED] Web:       http://www.biss.ro _____________________________________________________________________________________________________________________________ The content of this message and attachments are confidential and are classified as Best Internet Security's Proprietary Information. The content of this message is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action based on this information are strictly prohibited and may be precluded by law. Best Internet Security's is neither liable for the proper and complete transmission of the information contained in this message nor for any delay in its receipt.   ----- Original Message ----- From: syesilyurt To: [EMAIL PROTECTED] Sent: Thursday, January 09, 2003 9:54 AM 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