Sql-server – Running select filename from dbo.sysfiles returns short foldernames with tilde

sql serversql server 2014sql-server-2016

I am running the following statement in SQL Server 2014(in Windows 2012R2):

select filename from dbo.sysfiles where fileid = 1

However it returns:


I wish for the full path without the tilde.

(e.g C:\Program Files\Microsoft SQL Server\MSSQL12.SQL2014\MSSQL\DATA\master.mdf)

I tried upgrading the SQL Server 2014 Express to 2016 Express but it made no difference.

Any ideas?

Best Answer

If you use the non-deprecated equivalent sys.database_files view's column physical_name, does it provide you the full path?