space check

Question

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

HanShi SSC-Dedicated Points: 33519 More actions · Answer 1

Read the WMIC using the xp_cmdshell (if run with T-SQL):

DECLARE @cmd nvarchar(500)

SET @cmd = 'c:\windows\system32\wbem\wmic volume list brief'

EXEC master..xp_cmdshell @cmd

** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **