I would be curious to know how you do these mount points. Is something you do in SQL Server?
In any case, the last time I had to deal with a similar problem was when an ASP page executed a query and had to do a save of the ADO result set to a share which required a user and password to access. I never found a way to access this share without mapping it to a drive using WScript.Network's MapNetworkDrive method. But before doing so, the code would scan all existing mapped network drives to see if it's already mapped, etc. etc.
...Not that I expect that anyone would run out of drive letters...
- consider a cluster-node with a couple of instances topology driv1-data1 drive2-data2 drive3-log drive4-backup .... You'll run out of driveletters soon enough
- I've mounted the backupvolume in a folder of the logdrive for some of our instances.
Just to keep a reminder, this mounted-directory is named MOUNTED_bu, so it leaves a trace everywhere it is being used or may be used.
Jul 13
