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 »