Tags: xp_instance_regread

Return Default SQL Server Folder

Below script will query registry settings to return folder informations (SQL Root, Data, Log and Backup). I use this script to determine the default locations, put it in variables an use it for creating databases or backups. more »