Running select filename from dbo.sysfiles returns short foldernames with tilde

0 votes

1 answer

231 views

sql-server sql-server-2014 sql-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:

    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

Asked by dave (1 rep)

Feb 8, 2021, 09:45 PM
Last activity: Jun 6, 2025, 11:05 AM

Running select filename from dbo.sysfiles returns short foldernames with tilde

Related Questions