Tag: "xp_instance_regread"

Return Default SQL Server Folder

Posted on Mar 31, 2010 by in SQL Server
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. DECLARE @SQLDataRoot… more »