Get-SqlTransaction
Returns the current open transactions for a database.
Syntax
Get-SqlTransaction [[-sqlserver] <Object>] [-dbname] <Object> [<CommonParameters>]
Detailed Description
The Get-SqlTransaction function returns returns the current open transactions for a database.
Related Commands
Parameters
Name |
Description |
Required? |
Pipeline Input |
Default Value |
sqlserver |
|
false |
false |
|
dbname |
|
true |
false |
|
Input Type
None
You cannot pipe objects to Get-SqlTransaction
Return Values
System.Data.DataRow
Get-SqlTransaction returns an array of System.Data.DataRow.
Examples
EXAMPLE 1
Get-SqlTransaction "Z002\sql2k8" "pubs"
This command returns the current open transactoin in the pubs database.