John Mitchell-245523 (3/20/2013)
There's a limit to how small you can shrink a database. I can't remember off the top of my head what it its - I think it's either the size of the model database or the size of the database when it was created?
Why do you want to do this, anyway? If you shrink the database, it will only grow again, unless you're going to set it as read only.
Thank you so much for your input promptly.
If your statement is true, then the info on the properties of a database is confusing. The info on the properties of a database confuses people when they refer to the results when executing the sp_spaceused.
The setting in the model system database is used to set the default values. We may change any setting when creating any database, and also, we can change these settings after creating the database.
Shrinking the database such that it has zero available space is requested by our users. They use ithe database for creating reports.
Once again, tons of thanks to you.