sql server msde: In Query Analyzer, try this:

EXECUTE sp_spaceused

In Enterprise Mangler, right click on the database, choose [Properties]. The
file size is in the middle of the page on the [General] tab,

Also, you can use Windows Explorer to view the database file. (It's not a
precise measure, but it's close.)

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


[quoted text, click to view]

I have a small application that I've developed using MSDE (2K). I'm
going to put this in to production by setting up a new computer and it
seems that Server 2005 Express edition will be adequate for our needs.

I want to check that the size of the databases I'm using are less than
4GB. How do I do that? I've looked around in SQL Server Enterprise

Thanks, Arnie - I don't know why I couldn't find that :(

My db's are all in the single-digit MB size, so I guess that the 4GB
limit of the Express version won't be an issue. And of course, if it
ever becomes an issue, we just have to upgrade.

Thanks again.


On Sat, 11 Nov 2006 09:10:03 -0800, "Arnie Rowland" <arnie@1568.com>
[quoted text, click to view]