Get-SqlSysDatabases

Returns the result set from sysdatabases for the specified SQL server.

Syntax

Get-SqlSysDatabases [-sqlserver] <Object> [[-name] <String>] [<CommonParameters>]

Detailed Description

The Get-SqlSysDatabases function returns the result set from SysDatabases for the specified SQL server.

Related Commands

* Get-SqlSysDatabases

Parameters

Name Description Required? Pipeline Input Default Value
sqlserver    true  false   
name    false  false   

Input Type

None You cannot pipe objects to Get-SqlSysDatabases

Return Values

System.Data.DataRow Get-SqlSysDatabases returns an array of System.Data.DataRow.

Examples

EXAMPLE 1

Get-SqlSysDatabases "Z002\sql2k8"
This command returns the result set from SysDatabases for the Z002\sql2k8 SQL server.

EXAMPLE 2

Get-SqlSysDatabases "Z002\sql2k8" -name "pubs"
This command returns the result set from SysDatabases where the database name is like pubs.