Finding Default Database Path

• AndrewJacksonZA

  SSCarpal Tunnel

  Points: 4143

  More actions

  September 18, 2007 at 1:50 am

  #178471

  Hi

  How would one find the default database path for SQL Server 2005? Is there an environment variable that one could use? Currently our create database statement contains:

  FILENAME = 'c:\program files\microsoft sql server\mssql\data\X.mdf',

  What is a good way to genericise this? e.g. "$DEFAULT_DB_PATH$\X.mdf"

  Thank you

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  September 18, 2007 at 6:29 am

  #734276

  You need to query the registry.

  DECLARE

  @DefData nvarchar(200)

  EXEC

  master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE',N'Software\Microsoft\MSSQLServer\MSSQLServer',N'DefaultData', @DefData output

  SELECT

  @DefData

  Markus

  [font="Verdana"]Markus Bohse[/font]