InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 08:07:32 GMT20http://www.sqlservercentral.com/Forums/Topic1106767-146-1.aspxthnxsTue, 11 Dec 2012 03:28:44 GMTsalimdkg4http://www.sqlservercentral.com/Forums/Topic1106767-146-1.aspxitws workingthanxsTue, 11 Dec 2012 03:27:35 GMTsalimdkg4http://www.sqlservercentral.com/Forums/Topic1106767-146-1.aspxthanks guys. appreciate your time. i'll have a look @ those options now. Wed, 11 May 2011 06:30:49 GMTsnomadhttp://www.sqlservercentral.com/Forums/Topic1106767-146-1.aspxYou could always use SP_OACreate.Look at this thread for a possible script:-[url]http://www.sqlservercentral.com/Forums/Topic113227-5-1.aspx[/url]Wed, 11 May 2011 06:26:49 GMTIan Scarletthttp://www.sqlservercentral.com/Forums/Topic1106767-146-1.aspxIs powershell an option? I can't code with it but I'm sure google would solve that one for ya.<oi>sql?SSIS?Wed, 11 May 2011 06:22:35 GMTNinja's_RGR'ushttp://www.sqlservercentral.com/Forums/Topic1106767-146-1.aspx[quote][b]Syed Jahanzaib Bin hassan (5/11/2011)[/b][hr]declare @driveName varchar(100)declare @query varchar(1000)declare @fsinfo varchar(1000)set @driveName = 'C'set @query ='fsutil volume diskfree '+@driveName+':\' set @fsinfo = 'fsutil fsinfo volumeinfo '+@driveName+':\'exec xp_cmdshell @queryexec xp_cmdshell @fsinfocheck this T-SQL[/quote]Forgot to read again???Wed, 11 May 2011 06:21:25 GMTNinja's_RGR'ushttp://www.sqlservercentral.com/Forums/Topic1106767-146-1.aspxBy which I mean I'm prevented by standard operating procs here ... not that there's a technical issue in doing so.Wed, 11 May 2011 05:26:35 GMTsnomadhttp://www.sqlservercentral.com/Forums/Topic1106767-146-1.aspxThanks, but I can't use cmdshell - frustrating I know!Wed, 11 May 2011 05:23:34 GMTsnomadhttp://www.sqlservercentral.com/Forums/Topic1106767-146-1.aspxdeclare @driveName varchar(100)declare @query varchar(1000)declare @fsinfo varchar(1000)set @driveName = 'C'set @query ='fsutil volume diskfree '+@driveName+':\' set @fsinfo = 'fsutil fsinfo volumeinfo '+@driveName+':\'exec xp_cmdshell @queryexec xp_cmdshell @fsinfocheck this T-SQLWed, 11 May 2011 05:19:27 GMTSyed Jahanzaib Bin hassanhttp://www.sqlservercentral.com/Forums/Topic1106767-146-1.aspxFor policy reasons I can't enable cmdshell.I can get disk free space via xp_fixeddrives. But is it possible to get total disk space (ie. free space + used space).I need this for all drives (so can't minus SQL file sizes off free space as there are non sql files).I need to run on multiple instances & regularly.Thanks in advance!Wed, 11 May 2011 05:10:31 GMTsnomad