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. /************************
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar