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

[Ruud-Peeters]

Title: Message

Hi,   I run this script every week:   use issed Declare @EndDate datetime select @Enddate = eventdate from events where datediff(day,eventdate,getdate()) > '30' exec iss_purgeevents '01-01-2002', @EndDate, '1000'   It clears out all events that are between 01-01-2002 and 30 days ago. So you will be keeping data for 30 days. If you want to keep more, just increase the amount of days. I also backup the db's on a daily bases, and backup the logs every 6 hours, which truncates them. Ruud Peeters e-Commerce Engineering Europe Office Depot International -----Original Message----- From: syesilyurt [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 08:55 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