Preface
Overview of the Server Manager Command Line Interface
Usage Scenario: Using Server Manager CLI Commands to Run Replications
- Prerequisite Tasks for Running Replication Jobs from the Server Manager CLI
- Using the Server Manager CLI to Run Replications
  - Running a Scheduled Replication Job in Interactive Mode
  - Running a Scheduled Replication Job in Non-interactive Mode with Scripts
Command Reference

Command Line Interface for the Server Manager

9.7.0 HotFix 1

Back Next

get msdb list

Lists the Microsoft SQL Server databases for a specific SQL Server instance that runs on the Server Manager system, including the Change Data Capture settings for those databases.

Syntax

get msdb list Server_Manager_nameSQLServer_instance_name [mode={on|off|mixed|error}] [pattern=pattern]

The following short form is acceptable:

msdl Server_Manager_nameSQLServer_instance_name [mode={on|off|mixed|error}] [pattern=pattern]

Parameters

The following table describes the command parameters:

Parameter	Description
Server_Manager_name	The name of the Server Manager instance that runs on the Microsoft SQL Server system.
SQLServer_instance_name	The name of the Microsoft SQL Server instance for which to list databases and their Change Data Capture settings.
mode	A Change Data Capture setting to use for filtering the list of databases. Valid values are: on . Change Data Capture is enabled for all of the tables in the database. off . Change Data Capture is disabled for all of the tables in the database. mixed . The database includes tables with different Change Data Capture settings. error . The Server Manager encountered an error when retrieving the Change Data Capture settings for the database. By default, the command lists all of the databases for the specified instance, regardless of their Change Data Capture setting.
pattern	A comma-, semicolon-, or space-separated list of wildcard patterns that the Server Manager matches against database names to filter the databases for which to view the Change Data Capture settings. You can use the asterisk (*) and question mark (?) wildcards in the patterns. By default, the command lists all databases.

Examples

The following command lists databases of the MSSQLSERVER instance that runs on the Server Manager Main server system and the Change Data Capture settings for those databases:

get msdb list Main MSSQLSERVER

The following command lists databases of the same instance that have names beginning with DB_ and a Change Data Capture setting of on
:

msdl Main MSSQLSERVER pattern=DB_* mode=on

Rename Saved Search

Table of Contents

Command Line Interface for the Server Manager

Command Line Interface for the Server Manager

get msdb list

get msdb list

Syntax

Parameters

Examples