Wednesday, December 19, 2012

Finding Full Physical path of Master Database in SQL

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

No comments: