Required Help

Pl tell me this senario

if we create new database in sql 2000 with size 1024 KB now we insert 500 KB data in that database. so what is actual size of database now?

That depends how your database (files) is (are) extended. The default is defined by the model database which is by default 10Percent / unlimited unless you change the model database or the files in the appropiate database.

The next steps for extending the database would be in your case:

1MB
1,1 MB
1,21 MB
1,33 MB
1,46 MB
1,61 MB

(round about)

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Dear Jens,

Pl. tell me in brieaf