I disagree with the answer and believe it should be nvarchar. The documentation at http://technet.microsoft.com/en-us/library/gg492084.aspx shows that the path_locator is hierarchyid, but the name, which is defined as 'The file or directory name. ' is nvarchar. I could use the name to find something, not the hierarchyid.