November 20, 2009 at 7:04 am
We use SQL Server 2005 in a locked down shop, and xp_cmdshell is turned off by design. The DBAs do not have server console access, which means that we currently have to chase down a server administrator when we want to check to see how full a drive is. Unfortunately, the server monitoring of drive space fullness does not work effectively. 🙁
Is there a T-SQL command that will report drive fullness without having to have access to xp_cmdshell or the server console?
Or, maybe there is some SQL Server Management Studio feature that I am missing. (I am relatively new to SQL 2005, but I worked with prior versions of SQL Server extensively at a former shop.)
November 20, 2009 at 7:21 am
xp_fixeddrives
-Vikas Bindra
November 20, 2009 at 8:00 am
Great! Works like a champ. Thanks!
November 20, 2009 at 8:01 am
FYI -
I found this article which expands on a way to collect a running history of drive free space using xp_fixeddrives.
November 20, 2009 at 8:08 am
shew (11/20/2009)
FYI -I found this article which expands on a way to collect a running history of drive free space using xp_fixeddrives.
Thanks for sharing 🙂
-Vikas Bindra
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply