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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
