Exec master.sys.xp_fixeddrives
RESULT
Drive MB Free
***** *******
C 10002
D 20002
F 57481
This will be very useful before large data load operation. We can check the disk space before starting the any large data load processes
Wednesday, October 20, 2010
Find out Free disk space using SQL query
This code demonstrates use of master.sys.xp_fixeddrives. This returns all the drives available in the server and its free space in MB
This will be very useful before large data load operation. We can check the disk space before starting the any large data load processes
This will be very useful before large data load operation. We can check the disk space before starting the any large data load processes
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment