generateDetachScripts.ps1

param([parameter(Mandatory=$true)]$ServerInstance)
. "X:\pathTo\baseFunctions.ps1"
try {
$results = Invoke-Sqlcmd -Query "select @@servername" -ServerInstance $ServerInstance
}
catch {
"Check your spelling. You might have put in the wrong instance name or it is down: $ServerInstance"
exit
}
$serverName = $results.column1.replace('\', '_')
$serverDate = Get-Date -format "yyyy_MM_dd"
$fileName = "X:\savedScriptPath\" + $serverName + "_detach" + "_$serverDate.sql"
Set-Content $fileName "--Scripts for detaching all user databases on $ServerInstance"

# Get a list of user databases, then iterate through them one by oen for detach script generation
$results = getInstanceUserDb -ServerInstance $ServerInstance
$results | ForEach-Object {
	Add-Content $fileName ("--" + $_.name)
	Add-Content $fileName ("USE Master")
	Add-Content $fileName ("GO")
	Add-Content $fileName ("EXEC sp_detach_db @dbname = N'" + $_.name + "'")
}