deriving DB properties

3 Aug 2006 8:46 PM

Andrew

Using SQL SVR 2005 Express, when I right-click on a DB, a Properties dialog
appears,
with a default selection of 'General'. The second section of the grid that
appears is labeled
'Database', and shows properties including 'Size' and 'Space Available',
which I am interested
in monitoring via a Windows Service. Can someone please explain how to
programmatically
derive those values? Seems like it should be possible with just a few lines
of code....

3 Aug 2006 9:12 PM

Arnie Rowland

Go to www.Idera.com and download the free SQLCheck utility.

It may provide you with what you seek without much effort.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

"Andrew" <ashw***@cox.net> wrote in message

news:wgtAg.72870$fG3.68821@dukeread09...
Show quote

> Using SQL SVR 2005 Express, when I right-click on a DB, a Properties
> dialog appears,
> with a default selection of 'General'. The second section of the grid
> that appears is labeled
> 'Database', and shows properties including 'Size' and 'Space Available',
> which I am interested
> in monitoring via a Windows Service. Can someone please explain how to
> programmatically
> derive those values? Seems like it should be possible with just a few
> lines of code....
>

3 Aug 2006 10:09 PM

Anith Sen

Have you looked into using the system procedure sp_spaceused?

--
Anith