find the size of data base

Hi all

plz gives the exat query for finding size of database

Thanks
Samerendra Singh

Quote:

Originally Posted by samerendra

Hi all

plz gives the exat query for finding size of database

Thanks
Samerendra Singh

Hi Samerendra Singh,

You can find the size of the data base by right clicking on the data base go to properties you can find the data base size|||Hi Samerendra,
hope this helps you
The following statement returns the file size of the system dbspace, in pages.

SELECT DB_EXTENDED_PROPERTY( 'FileSize' );

if u want to check rightclick ur .db file inside sql win32 folder and chek for the size occupied.

Quote:

Originally Posted by samerendra

Hi all

plz gives the exat query for finding size of database

Thanks
Samerendra Singh

|||even if u need ur page size value to calculate this query will gice the page size allocated in bytes
SELECT DB_PROPERTY ( 'PageSize' );

Quote:

Originally Posted by samerendra

Hi all

plz gives the exat query for finding size of database

Thanks
Samerendra Singh