This should work:

sp_msforeachdb 'USE ?

select Name,

(convert(float,size)) * (8192.0/1048576) File_Size,

(convert(float,fileproperty(name,''SpaceUsed''))) * (8192.0/1048576) MB_Used,

((convert(float,size)) * (8192.0/1048576) - (convert(float,fileproperty(name,''SpaceUsed''))) * (8192.0/1048576)) MB_Free

from sysfiles

order by

fileproperty(name,''IsLogFile'')'

Have you tried deleting the data file(s) from the filegroup? If...

Sounds like the default database for the SQL...

Loner (11/10/2008)

---

I have to install SQL Server on Window 2000. There are 6 hard drives, 2 will be used to install the OS with 0+1 RAID.

So I will have...

Coss post - http://www.sqlservercentral.com/Forums/Topic597931-5-1.aspx

Executing sp_who2 in Query Analyzer will give you the most of the info in Current Activity

If it's just a handful of packages, you can open them to find the connections. However, if you have hundreds or thousands of packages it might be worth the $300...

I would agree with winash. You could create a new db with a smaller inital size and script out all the objects and data into the smaller db.

EDIT - oops,...

When using sp_spaceused, database_size includes the log file size but the free space in the log file is not included in unallocated_space.

My guess is you have a 9500MB log file...

Sounds like you may have to reinstall. Be sure to backup all system and user databases prior to the reinstall.

You can view schema changes by using the reports built into SSMS.

Right click on the database, Reports, Standard Reports, Schema Changes History

Might require SP2, can't remember off the top of...

If the BUILTIN|Administrators group is still in the logins for SQL, you can add your account to the local Administrators group on the machine which would give you sa access...

These links from BOL should give you a good idea of what is involved.

http://msdn.microsoft.com/en-us/library/ms191233(SQL.90).aspx

http://msdn.microsoft.com/en-us/library/ms178117(SQL.90).aspx

Is "Auto Close" enabled on the database? Is there anti-virus software which is allowed to scan inside the SQL folders? I have seen this error when a virus scanner is...

Actually, you can do a shrinkfile with empty on the primary data file. You can shrink it down...