sp_helpdb

Execute sp_helpdb within a database, and specify the database's name to see information about the segments in the database.

For example:

sp_helpdb pubs2

name      db_size    owner     dbid created        status
--------- ---------- --------- ---- -------------- --------------
pubs2     20.0 MB     sa           4 Apr 25, 2005   select
     into/bulkcopy/pllsort, trunc log on chkpt, mixed log and data

device_fragments    size          usage         created      free kbytes
------------------- ------------- ------------- ----------   ------------
master              10.0MB        data and log  Apr 13 2005          1792

pubs_2_dev         10.0MB        data and log  Apr 13 2005         9888

device                 segment
---------------------- ----------------------
master                 default
master                 logsegment
master                 system
pubs_2_dev             default
pubs_2_dev             logsegment
pubs_2_dev             system
pubs_2_dev             seg1
pubs_2_dev             seg2