SQL QuestionBrian, Deleting entries does not get rid of what is often referred to the 'high water mark'. Meaning that space is still allocated to the table.. What you need to do is truncate the tables in question (both the t and h tables)
Syntax for truncate is truncate table Txxx; truncate table Hxxx; Truncate is followed by an auto commit so even if you were on Oracle, you would not need to commit after a truncate.. If this still doesn't, shrink your SQL database, use the shrink feature of the database after you have truncated the two tables.. Cheers Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Sokol, Brian Sent: Friday, April 04, 2008 12:37 PM To: arslist@ARSLIST.ORG Subject: SQL Question ** Hi Our Remedy database (MS Sql 2000) has grown from 4GB to 52GB in the past few months. I had turned on auditing for our asset database . The auditing table is huge. That was the cause. I turned off auditing and then late last night deleted the table from ARAdmin. I no longer see the table in Remedy but it's T table is still in SQL with all the data. I am by no stretch of the imagination a DBA so sorry if this is a dumb question. Why is that table still there and how do I get rid of the massive amount of data. thanks Brian Sokol Manager, Desktop Services Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 http://www.Scholastic.com No virus found in this outgoing message. Checked by AVG. Version: 7.5.519 / Virus Database: 269.22.5/1359 - Release Date: 4/4/2008 8:23 AM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
