XP_FixedDrives shows negative values for drive > 1 TB

  • XP_FixedDrives show negative values for local drives > 1 TB on sql server 2000. Any ideas why....

  • The only thing I can think of is if the .dll for xp_fixeddrives uses 40 bit integers for some reason. If unsigned, that would make the largest value 1,099,511,627,775. If I had two local drives, one slightly larger than this and one slightly smaller, then I'd check it out for you, but unfortunately I don't.

  • Please do not cross post ... this is 1 of 3 !

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

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

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