By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,574 Members | 1,977 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,574 IT Pros & Developers. It's quick & easy.

Re: Datadevices

P: n/a
>--- On Sun, 9/7/08, ph3ng <jt****@gmail.comwrote:
>
>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?
Please reply to the newsgroup so that the discussion may help others
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
Sep 8 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Sep 8, 11:20*am, "Roy Harvey (SQL Server MVP)"
<roy_har...@snet.netwrote:
--- On Sun, 9/7/08, ph3ng <jth...@gmail.comwrote:
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?

Please reply to the newsgroup so that the discussion may help others
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
Hi Roy

Thanks for that. sorry about replying it privately. I will give that a
try. Thank you.

Regards

Justin
Sep 8 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.