Drive Letter Finder

• darren.sunderland

  Mr or Mrs. 500

  Points: 531

  More actions

  November 11, 2009 at 7:24 pm

  #216694

  Comments posted to this topic are about the item Drive Letter Finder

• mstjean

  Hall of Fame

  Points: 3310

  More actions

  November 17, 2009 at 4:33 pm

  #1080615

  I think this'll give you the same result with a lot less work:

  declare @Foo table (drive char(1),mbfree int)

  INSERT INTO @Foo EXEC master..xp_fixeddrives

  IF @@rowcount = 26

  SELECT '*' as drive

  ELSE

  SELECT TOP 1 drive FROM @Foo ORDER BY drive

  Or to see all the details:

  declare @Foo table (drive char(1),mbfree int)

  INSERT INTO @Foo EXEC master..xp_fixeddrives

  SELECT * FROM @Foo

  Warning; xp_fixeddrives IS undocumented

  ---

  Cursors are useful if you don't know SQL

• Gary Varga

  SSC Guru

  Points: 82166

  More actions

  November 18, 2009 at 3:29 am

  #1080776

  A small point - VERY SMALL - is that Available is spelt incorrectly. Thought you might want to correct the article.

  Gaz

  -- Stop your grinnin' and drop your linen...they're everywhere!!!