space available in database...

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

Eric:

I am now working in SQL7.0.

I want to calculate how much free space is available in the database. My database size would be:1390Mb. Growth size is 0.

Tahnks,

Kothans.

-- Anonymous, November 08, 1999

Answers

Kothans,

How to display data and log space information for a database (Enterprise Manager)

To display data and log space information for a database

Expand a server group; then expand a server. Expand Databases; then click the database to view. In the details pane, click Space Allocated to view database space information.

In T-SQL, you can use sp_spaceused.

Hope this helps,

Eric

-- Anonymous, November 08, 1999


Moderation questions? read the FAQ