August 4, 2004 at 12:45 pm
I am running xp_fixeddrives on a server that have the following logical drives (Local):
C, D(CD-ROM), E, F, M, L, T, H
The result only shows C, E, L, F, M. I can understand why D doesn't show - is a CDROM. But what about T and H?
Is there any limitation in the number displayed? Is there any parameter I should apply?
Thanks.
August 4, 2004 at 12:50 pm
xp_fixeddrives is intended to return information on hard drives and the free space available. A CD-ROM is technically removable.
K. Brian Kelley
@kbriankelley
August 4, 2004 at 12:54 pm
Yes, I can understand this and I don't expect the CDROM to be inlcuded in the result set. But I expect to see the fixed drives H and T and they are not in the output!
August 4, 2004 at 1:05 pm
Are T and H mapped drives or are they allocated at the system level?
August 4, 2004 at 1:35 pm
No, they are not mapped. They correspond to physical drives connected to the system.
August 4, 2004 at 1:40 pm
That's a lot of drives. This isn't a cluster, per chance? With the drives on the other node?
K. Brian Kelley
@kbriankelley
August 5, 2004 at 12:48 am
XP_FIXEDDRIVES does see the shared drives in a cluster here. The drive configuration may be an issue - I think XP_FIXEDDRIVES only returns info on Fixed hard drives.
Do you have any sneaky partitioning in place ?
Try XP_AVAILABLEMEDIA (tinyint)
Otherwise, maybe someone knows more about the undocumented XP's.
The systems fine with no users loggged in. Can we keep it that way ?br>
August 5, 2004 at 7:09 am
Thank you all for your advices.
I think I solved it. It was a security issue. Even if my windows account had full access to those 2 drives and the xp_fixeddrives ran in one of my sessions with Windows NT authentication, the fact that domain account for SQL Server service didn't have access made all the difference.
Now that I know the cause I can think about the remedies!
Gabriela
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply