Creating/Sharing the folder on the fileserver will also require administrative privileges if security is set properly.code:
USE H: '\\server1\'+@USERID+'$$'
will work. You forget the backslash between the servername and the username.
_________________________
There are two types of vessels, submarines and targets.
