Thank you to the both of you. Please excuse my typo. In the script it is as both of you suggested:
code:
 USE P: "\\SERVER01\Scans\" + @USERID 

I was going from memory here at home. Just for good measure I tried here on my test lab and am not able to get it to work.

However, I am able to get the H:\ drive to work. Simply replace "SCANS" from above with "USERS". Go figure.

This is really starting to frustrate me. [Confused]

Sorry!

Thanks again,

Cary