Tag: "xp_instance_regread"
Return Default SQL Server Folder
Mar 31st
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 »