yeah this was from my SQL 2000 notes, so we are talking really old school code;
It Used to be possible to map a drive by throwing a key in the registry @ HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Run, and having a key there to call a bat file or other executable, which ran the NET USE command. an executable woudl at least mask the password.
I think that registry key is mostly disabled on most machines due to it's abuse; i stopped using it long ago.
it has been a zillion days since i ever had to look at this issue, since it's a lot easier to fix in other ways, like impersonation in a powershell or scheduled task or something similar, right?
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!