SQL 6.5 | NT 4 (SP3)
I am currently maintaining a SQL Server Data Base which has two tables.
At the first of each month, in one of the tables, records older than 3
months are deleted by a scheduled TSQL statement. After several months
of this activity, it has come to my attention that though the records
are deleted the space still seems to be in use (the max alloted size of
the db is used up). However, new records are still being written to the
db without error. It is my guess that the record data is being deleted
on schedule, but the meta data for the data isn't.
I know in MS Access there is an option to compact or compress a db and
I'm wondering if there is an option like this for MS SQL Server or will
this even solve the problem at all?
Gary C. New "Web Development, SMIP Interactive"
Smip Interactive, Inc. v 703.442.5210 x233
http://www.smip.com f 703.442.5205
Comics, advice, horoscopes and opinion - all the best in online