bri189a Posted March 18, 2004 Posted March 18, 2004 Do you have to worry about compacting the database with MSDE as you do with Access or is that an Access only problem? Quote
Administrators PlausiblyDamp Posted March 18, 2004 Administrators Posted March 18, 2004 You do not have to worry about it as much as with access. If you do wish to reclaim free space you can issue the command DBCC SHRINKDATABASE e.g. dbcc shrinkdatabase (databasename,10) will shrink the database but leave 10% of the new file size as free space. This isn't always going to reclaim all the free space but it is quick. Unlike access this can be executed while users are still accessing the database. Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
bri189a Posted March 22, 2004 Author Posted March 22, 2004 PD - thanks... for the other response too with the DataList...looking into that...MSDE gets cooler and cooler now that I finally got it working...I imagine when the DB needs to grow it grows on it own, and I didn't realize (and maybe I'm wrong but it seems this way) all these commands you could do as querys and not have to use the OSQL utility... that's very cool... very, very cool. Now if I can figure out an easy way to deploy.... Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.