Yes,the id does have access to the directory path.

The value of gvFileLocation is typed incorrectly in the posting it really is:

Value of gvFileLocation is "\\SrvrName\D$\CMSReporting\Data\AHT_Skilled"

Here is the script to add the view. (sorry, couldn't figure out how to properly format with in the forum window, looks okay in posting window)

SET QUOTED_IDENTIFIER OFF

GO

SET...