I am running the following statement in SQL Server 2014(in Windows 2012R2):
select filename from dbo.sysfiles where fileid = 1
However it returns:
c:\progra~1\micros~1\mssql1~1.sql\mssql\data\master~1.mdf
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? Thanks. Dave