You couldn't have expanded the databases without having free space in a device first.
Run this code in a query window and post the ouptut so that we can see what you have.
use master
go
set nocount on
declare @mess varchar(200)
select @mess = 'Server ' + @@SERVERNAME + ' at ' +
convert(varchar(50), getdate(),111) +' ' +convert(varchar(50), getdate(),114)
print ' '
print @mess
print ' '
print 'Display Database Segment Sizes'
print ' '
go
set nocount off
go
select
--a.dbid,
DB_Name = a.name,
--b.segmap,
Segment_Type =
convert(varchar(15),
case b.segmap
when 3 then 'Data'
when 4 then 'Log'
when 7 then 'Data and Log'
else 'Unknown'
end),
--Segment_Size = b.size,
Seg_Megabytes = (b.size * 2) / (1024) ,
--b.Lstart ,
--DB_Creation_Date = a.crdate,
--Current_Date_Time = getdate(),
Device_Name = c.Name,
Device_Path = c.phyname
--,b.Vstart,
--c.Low,
--c.High
from
master.dbo.sysdatabases a,
master.dbo.sysusages b,
master.dbo.sysdevices c
where
a.dbid = b.dbid and
b.vstart >= c.low and
b.vstart <= c.High and
c.high > 19 and
c.phyname <> 'nul'
order by
a.dbid, b.lstart
go
print ' '
print 'Display Database Devices'
print ' '
go
set nocount on
go
select
DeviceNumber =
case
when name = 'master'
then 0
when convert(int,convert(binary(1), (low / 0x01000000))) = 0
then convert(smallint,null)
else convert(smallint,convert(int,convert(binary(1), (low / 0x01000000))))
end,
*
into
#t1
from
master..sysdevices
go
set nocount off
go
select
DeviceNumber ,
low ,
high ,
name ,
phyname
--*
--status ,
--cntrltype ,
--mirrorname ,
--stripeset
from
#t1
where
DeviceNumber is not null
order by
DeviceNumber,
Name
go
drop table #t1
go
print ' '
print 'End'
print ' '
CODO ERGO SUM