Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Actual size of database

Author  Topic 

U2000
Starting Member

1 Post

Posted - 2008-02-28 : 08:03:00
how do i check the actual size of files stored in a database in SQL 2000 Server .

Umesh P

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2008-02-28 : 08:36:36
Do you mean size of data file of the database?

select FILEPROPERTY ('file1', 'SpaceUsed')


Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page
   

- Advertisement -