MSDE2000
What type of maintenance should be built into an application using MSDE. I have a backup/restore procedure that works well, but I was thinking that I should have a procedure for running DBCC SHRINKDATABASE as well. In addition, how do you maintain indexes using TSQL commands?
Any help is appreciated.
--
Tim Morrison
What type of maintenance should be built into an application using MSDE. I have a backup/restore procedure that works well, but I was thinking that I should have a procedure for running DBCC SHRINKDATABASE as well. In addition, how do you maintain indexes using TSQL commands?
Any help is appreciated.
--
Tim Morrison