>Please reply to the newsgroup so that the discussion may help others>Thanks for your reply. I believe I am currently using:
Microsoft SQL Server 2000.
I am not too well versed with the the history of sysdevices
- and
appreciate the background info that you've given me.
When I use sp_helpdb (which I have done previously),
doesn't this
generate a list of all the databases currently on the
server as well
as the size for each db? If this is correct, then I would
still only
have 'space used' and not total space allocated on
the device. Is this
correct?
too.
If you just run sp_helpdb without any parameter you get a list of
databases with some information on each. If you execute it with a
database name as a parameter it returns considerably more detail about
that specific database, including the size (total space allocated) of
each database file. In SQL Server 2000 the source to sp_helpdb can be
found in the master database.
Roy Harvey
Beacon Falls, CT