Post reply

output of xp_availablemedia

  • April 28, 2009 at 10:31 pm

    #204066

    Hi friends,

    Here i am having a query which is already existed in SQL server. By executing this i am getting the output as follows.Pls ley me know what are these column names representing

    name low free high free media type

    C:\24361369612

    E:\146576179282

    tell me what these terms lowfree, highfree, mediatypr represents exactly?

    Thank u all

    Venu Gopal.K
    Software Engineer
    INDIA

  • April 29, 2009 at 3:21 am

    #985712

    The last column media type is small int. It is mapped to different media types as

    1 for Floppy

    2 for Hard Disk

    8 for CD-ROM

    4 for Tape

    16 for Shared Disk

    DBDigger Microsoft Data Platform Consultancy.

  • April 29, 2009 at 3:24 am

    #985715

    Hi asheshad thank u for u valuable answer,

    but can u tell me what is the exact meaning of low free, high free also

    Thank You ,

    Venu Gopal.K
    Software Engineer
    INDIA

  • April 29, 2009 at 2:52 pm

    #986281

    The output will display the name - which is the name of the drive; low free displays the available free space and media type displays the type of media namely CD-ROM(8), Floppy(1), Hard Drive(2).

    MJ

  • February 8, 2010 at 10:53 am

    #1115673

    Does anybody know what it means when the "low free" column of xp_availablemedia is a negative number? It's not always negative, but it often is.

    I'm trying to get the free space of an external usb drive, which doesn't show up in xp_fixeddrives. Availablemedia shows the "low free" as -1232883712. Also, what is "high free"?

    Thanks

Viewing 5 posts - 1 through 4 (of 4 total)

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