Running select filename from dbo.sysfiles returns short foldernames with tilde
If you use the non-deprecated equivalent sys.database_files view's column physical_name, does it provide you the full path?