Sunday, February 26, 2012

FILE SIZE IN MODEL

Hi,
where Can I see the default size of new database in database MODEL ?

In which table ?

Saimon(Florence)Unless you specify otherwise, new databases will be created the same size as
model. You can query the model database properties with:

EXEC sp_helpdb 'model'

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Saimon" <saimon181072@.supereva.it> wrote in message
news:c53q0m$on9$1@.newsreader.mailgate.org...
> Hi,
> where Can I see the default size of new database in database MODEL ?
> In which table ?
> Saimon(Florence)

No comments:

Post a Comment