While playing around with a SCSM MP, I needed to somehow dynamically get the SQL server hostname that holds the SCSM database.

I found it on the registry on the SCSM server in the HLKM hive under:

Software\Microsoft\System Center\2010\Common\Database

key: DatabaseServerName