InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 06:37:14 GMT20http://www.sqlservercentral.com/Forums/Topic817573-1217-1.aspxA small point - VERY SMALL - is that [i][b]Available[/b][/i] is spelt incorrectly. Thought you might want to correct the article.Wed, 18 Nov 2009 03:29:08 GMTGary Vargahttp://www.sqlservercentral.com/Forums/Topic817573-1217-1.aspxI think this'll give you the same result with a lot less work:[code="sql"]declare @foo table (drive char(1),mbfree int)INSERT INTO @foo EXEC master..xp_fixeddrivesIF @@rowcount = 26 SELECT '*' as driveELSE SELECT TOP 1 drive FROM @foo ORDER BY drive[/code]Or to see all the details:[code="sql"]declare @foo table (drive char(1),mbfree int)INSERT INTO @foo EXEC master..xp_fixeddrivesSELECT * FROM @foo[/code]Warning; xp_fixeddrives IS undocumentedTue, 17 Nov 2009 16:33:00 GMTmstjeanhttp://www.sqlservercentral.com/Forums/Topic817573-1217-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/TSQL/68695/">Drive Letter Finder</A>[/B]Wed, 11 Nov 2009 19:24:24 GMTdarren.sunderland