SELECT SUBSTRING(filename, 1, CHARINDEX(N'master.mdf', LOWER(filename)) - 1) FROM master.dbo.sysdatabases WHERE name = 'master'
This query Return Full physical path till Data Folder in SQL
This query Return Full physical path till Data Folder in SQL
No comments:
Post a Comment