SQL Server with Mr. Denny:

xp_fixeddrives

1

April 28, 2008  9:00 AM

Checking free disk space from T/SQL



Posted by: Denny Cherry
SQL, T/SQL, xp_fixeddrives

I've seen some very creative ways to see how much free disk space SQL Servers have.  Most make use of xp_cmdshell which some very complex dos commands or vbscripts. However there is a much easier way.  Microsoft has included the system extended stored procedure xp_fixeddrives.  It returns the...

1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: