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

* Get-SqlTransaction

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.