http://sqlblog.com/blogs/jamie_thomson/archive/2012/12/10/query-for-server-defaultdata-defaultlog-folders.aspxDo you ever need to query for the DefaultData &amp; DefaultLog folders for your SQL Server instance? Well, I just did and the following script enabled me to do that: DECLARE @HkeyLocal NVARCHAR ( 18 ), @MSSqlServerRegPath NVARCHAR ( 31 ), @InstanceRegPathenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlblog.com/blogs/jamie_thomson/archive/2012/12/10/query-for-server-defaultdata-defaultlog-folders.aspx#46584Mon, 10 Dec 2012 17:50:45 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:46584Cliff<p>The folks over at SqlSlayer.com have an admin database put together that has some functions for getting default directories. Full Discolsure, it's run by friends of mine, and I;ve written a couple posts for the site. It is free and open source.</p> http://sqlblog.com/blogs/jamie_thomson/archive/2012/12/10/query-for-server-defaultdata-defaultlog-folders.aspx#46616Wed, 12 Dec 2012 07:28:06 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:46616Vishal<p>Handy script. I have also written a post earlier to extract default data paths for multiple instances.</p> <p><a rel="nofollow" target="_new" href="http://sqlandme.com/2012/01/05/sql-server-identifying-default-data-directory-for-multiple-instances-through-registry/">http://sqlandme.com/2012/01/05/sql-server-identifying-default-data-directory-for-multiple-instances-through-registry/</a></p> <p>Thanks,</p> <p>Vishal</p>