Cmdlets/Undo-SqlTransaction.ps1
|
<#
.Synopsis Undo a sql transaction. .Description Undo (ROLLBACK) a sql transaction. .Parameter ConnectionName User defined name for connection. #> Function Undo-SqlTransaction { [cmdletBinding()] Param([Parameter(Position=0)][ValidateNotNullOrEmpty()][Alias("cn")][string]$ConnectionName = "default") If(TestConnectionName -ConnectionName $ConnectionName) { try { $Script:Connections.$ConnectionName.RollbackTransaction() } catch { Write-Warning "Received an error while Undoing the transaction, usually this means a timeout has expire and you can safely ignore: $_." if($Script:Connections.$ConnectionName.Transaction) { $Script:Connections.$ConnectionName.Transaction.Dispose() $Script:Connections.$ConnectionName.Transaction = $null } if($Script:Connections.$ConnectionName.Connection.State -eq "Closed") { $Script:Connections.$ConnectionName.Connection.Open() } } } } Export-ModuleMember -Function Undo-SqlTransaction |