Minggu, 03 April 2011

SQL Server: TSQL Script to Get Hard Drives Detail

Recently, I need a script which can provide me detail (Driver Letter, Drive Label, Free Space, Used Space etc) of all installed hard drives. I found following script by G. Rayburn very helpful. Valid for versions: SQL Server 2005 and aboveNote: Before executing script, don't forget to enable Ole Automation Procedures from Surface Area Configuration or using sp_configure. /************************

Tidak ada komentar:

Posting Komentar