Why So Big?

I am trying to test out the new security components that come with VS 2005 and have a local database created in my App_Data folder for it. I have 2 user accounts added and about 10 roles that I've created. The database however is 10mb in size. Why is it so big. If I enter 100 users is it going to grow to a GB?

Thanks,

glenn

That's the standard initial size of a SQL Server database file. When the contents reach 10 MB it will increase by another 10 MB to 20 MB. This is a strategy to allow databases to grow by 'reserving' space on the disk.

ok, I guess I understand that you are telling me it grows in blocks instead of based on what is actually in it, but disagree that this would be some form of conserving disk space... :-) but thanks...

glenn

It's "reserving" disk space, not "conserving" it.

:)

lol, ah, misread it... Thanks...

glenn