Can a SQL Server stored procedure do that ?

There is a stored procedure, namely sp_spaceused, to find out the space used
of a particular database.
But now, I also want to record the free hard disk space of each of my
server's logical drives, eg. C drive, D drive, ... into my SQL Server
database, is there any stored procedure just like sp_spaceused to find a
logical disk's free space ?
Try this undocumented xp:
master.dbo.xp_fixeddrives
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:ca9qn3$oec1@.imsp212.netvigator.com...
> There is a stored procedure, namely sp_spaceused, to find out the space
used
> of a particular database.
> But now, I also want to record the free hard disk space of each of my
> server's logical drives, eg. C drive, D drive, ... into my SQL Server
> database, is there any stored procedure just like sp_spaceused to find a
> logical disk's free space ?
>
|||you can take a look at following url.
http://www.databasejournal.com/scrip...le.php/1470811
Vishal Parkar
vgparkar@.yahoo.co.in | vgparkar@.hotmail.com
|||More information about how xp_fixeddrives might be used.
http://databasejournal.com/features/...le.php/3080501
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:ca9qn3$oec1@.imsp212.netvigator.com...
> There is a stored procedure, namely sp_spaceused, to find out the space
used
> of a particular database.
> But now, I also want to record the free hard disk space of each of my
> server's logical drives, eg. C drive, D drive, ... into my SQL Server
> database, is there any stored procedure just like sp_spaceused to find a
> logical disk's free space ?
>

Can a SQL Server Stored Procedure do that ?

There is a stored procedure, namely sp_spaceused, to find out the space used
of a particular database.
But now, I also want to record the free hard disk space of each of my
server's logical drives, eg. C drive, D drive, ... into my SQL Server
database, is there any stored procedure just like sp_spaceused to find a
logical disk's free space ?
There's a proc called xp_fixeddrives. It is not documented, though, so all usual warnings applies.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"cpchan" <cpchaney@.netvigator.com> wrote in message news:c9sjpn$afq3@.imsp212.netvigator.com...
> There is a stored procedure, namely sp_spaceused, to find out the space used
> of a particular database.
> But now, I also want to record the free hard disk space of each of my
> server's logical drives, eg. C drive, D drive, ... into my SQL Server
> database, is there any stored procedure just like sp_spaceused to find a
> logical disk's free space ?
>
>
|||it's not not officially supported but take a look at
xp_fixeddrives
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:c9sjpn$afq3@.imsp212.netvigator.com...
> There is a stored procedure, namely sp_spaceused, to find out the space
used
> of a particular database.
> But now, I also want to record the free hard disk space of each of my
> server's logical drives, eg. C drive, D drive, ... into my SQL Server
> database, is there any stored procedure just like sp_spaceused to find a
> logical disk's free space ?
>
>

Can a SQL Server stored procedure do that ?

There is a stored procedure, namely sp_spaceused, to find out the space used
of a particular database.
But now, I also want to record the free hard disk space of each of my
server's logical drives, eg. C drive, D drive, ... into my SQL Server
database, is there any stored procedure just like sp_spaceused to find a
logical disk's free space ?Try this undocumented xp:
master.dbo.xp_fixeddrives
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:ca9qn3$oec1@.imsp212.netvigator.com...
> There is a stored procedure, namely sp_spaceused, to find out the space
used
> of a particular database.
> But now, I also want to record the free hard disk space of each of my
> server's logical drives, eg. C drive, D drive, ... into my SQL Server
> database, is there any stored procedure just like sp_spaceused to find a
> logical disk's free space ?
>|||you can take a look at following url.
http://www.databasejournal.com/scri...cle.php/1470811
Vishal Parkar
vgparkar@.yahoo.co.in | vgparkar@.hotmail.com|||More information about how xp_fixeddrives might be used.
http://databasejournal.com/features...cle.php/3080501
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:ca9qn3$oec1@.imsp212.netvigator.com...
> There is a stored procedure, namely sp_spaceused, to find out the space
used
> of a particular database.
> But now, I also want to record the free hard disk space of each of my
> server's logical drives, eg. C drive, D drive, ... into my SQL Server
> database, is there any stored procedure just like sp_spaceused to find a
> logical disk's free space ?
>

Can a SQL Server Stored Procedure do that ?

There is a stored procedure, namely sp_spaceused, to find out the space used
of a particular database.
But now, I also want to record the free hard disk space of each of my
server's logical drives, eg. C drive, D drive, ... into my SQL Server
database, is there any stored procedure just like sp_spaceused to find a
logical disk's free space ?There's a proc called xp_fixeddrives. It is not documented, though, so all u
sual warnings applies.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"cpchan" <cpchaney@.netvigator.com> wrote in message news:c9sjpn$afq3@.imsp212.netvigator.com.
.
> There is a stored procedure, namely sp_spaceused, to find out the space us
ed
> of a particular database.
> But now, I also want to record the free hard disk space of each of my
> server's logical drives, eg. C drive, D drive, ... into my SQL Server
> database, is there any stored procedure just like sp_spaceused to find a
> logical disk's free space ?
>
>|||it's not not officially supported but take a look at
xp_fixeddrives
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:c9sjpn$afq3@.imsp212.netvigator.com...
> There is a stored procedure, namely sp_spaceused, to find out the space
used
> of a particular database.
> But now, I also want to record the free hard disk space of each of my
> server's logical drives, eg. C drive, D drive, ... into my SQL Server
> database, is there any stored procedure just like sp_spaceused to find a
> logical disk's free space ?
>
>

Can a SQL Server stored procedure do that ?

There is a stored procedure, namely sp_spaceused, to find out the space used
of a particular database.
But now, I also want to record the free hard disk space of each of my
server's logical drives, eg. C drive, D drive, ... into my SQL Server
database, is there any stored procedure just like sp_spaceused to find a
logical disk's free space ?Try this undocumented xp:
master.dbo.xp_fixeddrives
--
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:ca9qn3$oec1@.imsp212.netvigator.com...
> There is a stored procedure, namely sp_spaceused, to find out the space
used
> of a particular database.
> But now, I also want to record the free hard disk space of each of my
> server's logical drives, eg. C drive, D drive, ... into my SQL Server
> database, is there any stored procedure just like sp_spaceused to find a
> logical disk's free space ?
>|||you can take a look at following url.
http://www.databasejournal.com/scripts/article.php/1470811
--
Vishal Parkar
vgparkar@.yahoo.co.in | vgparkar@.hotmail.com|||More information about how xp_fixeddrives might be used.
http://databasejournal.com/features/mssql/article.php/3080501
--
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:ca9qn3$oec1@.imsp212.netvigator.com...
> There is a stored procedure, namely sp_spaceused, to find out the space
used
> of a particular database.
> But now, I also want to record the free hard disk space of each of my
> server's logical drives, eg. C drive, D drive, ... into my SQL Server
> database, is there any stored procedure just like sp_spaceused to find a
> logical disk's free space ?
>

Can a SQL Server Stored Procedure do that ?

There is a stored procedure, namely sp_spaceused, to find out the space used
of a particular database.
But now, I also want to record the free hard disk space of each of my
server's logical drives, eg. C drive, D drive, ... into my SQL Server
database, is there any stored procedure just like sp_spaceused to find a
logical disk's free space ?There's a proc called xp_fixeddrives. It is not documented, though, so all usual warnings applies.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"cpchan" <cpchaney@.netvigator.com> wrote in message news:c9sjpn$afq3@.imsp212.netvigator.com...
> There is a stored procedure, namely sp_spaceused, to find out the space used
> of a particular database.
> But now, I also want to record the free hard disk space of each of my
> server's logical drives, eg. C drive, D drive, ... into my SQL Server
> database, is there any stored procedure just like sp_spaceused to find a
> logical disk's free space ?
>
>|||it's not not officially supported but take a look at
xp_fixeddrives
--
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:c9sjpn$afq3@.imsp212.netvigator.com...
> There is a stored procedure, namely sp_spaceused, to find out the space
used
> of a particular database.
> But now, I also want to record the free hard disk space of each of my
> server's logical drives, eg. C drive, D drive, ... into my SQL Server
> database, is there any stored procedure just like sp_spaceused to find a
> logical disk's free space ?
>
>