RE: [SQLDownUnder] xp_fixeddrives Stored Procedure

[Greg Low]

Hi Martin,

 

Are they definitly fixed and not mapped drives?

 

Regards,

Greg

Dr Greg Low
Readify - Senior Consultant

M:	+61 419 201 410
	Office Communicator

 

---

From: SQLDownUnderList@xxxxxxxxxxxxxxxxxxxxxx [mailto:SQLDownUnderList@xxxxxxxxxxxxxxxxxxxxxx] On Behalf Of Cairney, Martin H
Sent: Tuesday, 5 September 2006 10:22 AM
To: SQLDownUnder@xxxxxxxxxxxxxxxxxxxxxx
Subject: [SQLDownUnder] xp_fixeddrives Stored Procedure

Has anyone experienced the xp_fixeddrives stored procedure not returning data on all the drives on the system?

 

I have 1 system where only the C: drive is returned from the SP - all other systems return the full listing.     The system is SQL Server 2005 SP1 on Windows 2003 R2 SP1  ... however I have other servers with the same configuration where it does work OK.

 

Any ideas on where to look to get this working would be appreciated.

Martin Cairney  
EDS | Australia ADU | Data Engineering Capability - DBA |
Level 10, 108 North Terrace, Adelaide, S.A. 5000 |

 

to unsubscribe to this list, please send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by http://www.readify.net to unsubscribe to this list, please send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by http://www.readify.net