InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 10:09:06 GMT20http://www.sqlservercentral.com/Forums/Topic525288-146-1.aspxData:[code]-- ***************************************************************************-- nvarchar(4000) = dbo.fn_SQLServerDataDir()-- ***************************************************************************IF OBJECT_ID('SQLServerDataDir_fn','FN') IS NOT NULL DROP FUNCTION SQLServerDataDir_fnGOcreate function dbo.SQLServerDataDir_fn()returns nvarchar(4000)asbegindeclare @rc int,@dir nvarchar(4000)exec @rc = master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE',N'Software\Microsoft\MSSQLServer\MSSQLServer',N'DefaultData', @dir output, 'no_output'if (@dir is null)beginexec @rc = master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE',N'Software\Microsoft\MSSQLServer\Setup',N'SQLDataRoot', @dir output, 'no_output'select @dir = @dir + N'\Data'endreturn @dirend[/code]Log[code]-- ***************************************************************************-- nvarchar(4000) = dbo.SQLServerLogDir_fn()-- ***************************************************************************IF OBJECT_ID('SQLServerLogDir_fn','FN') IS NOT NULL DROP FUNCTION SQLServerLogDir_fnGOcreate function dbo.SQLServerLogDir_fn()returns nvarchar(4000)asbegindeclare @rc int,@dir nvarchar(4000)exec @rc = master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE',N'Software\Microsoft\MSSQLServer\MSSQLServer',N'DefaultLog', @dir output, 'no_output'if (@dir is null)beginexec @rc = master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE',N'Software\Microsoft\MSSQLServer\Setup',N'SQLDataRoot', @dir output, 'no_output'select @dir = @dir + N'\Data'endreturn @dirend[/code]Fri, 27 Jun 2008 13:39:40 GMTAdam Beanhttp://www.sqlservercentral.com/Forums/Topic525288-146-1.aspxI'm struggling to find a way to get the default data and log locations using t-sql. Is there a way to either do this without reading the registry? if not, does anyone have a script that will grab those values from the registry regardless of default/named instance?I have one that works well for default instance, but I need one I can drop on any server and have it grab those values correctly.Any help would be greatly appreciated.ThanksFri, 27 Jun 2008 12:51:53 GMTAdam Angelini