Jaa


MSdbms (Transact-SQL)

The MSdbms table contains a master list of all versions of the database management systems (DBMS) supported for heterogeneous database replication. This table is stored in the msdb database.

Column name Data type Description

dbms_id

int

Identifies each unique DBMS and version.

dbms

sysname

The DBMS name.

  • MSSQLSERVER
  • DB2
  • ORACLE
  • SYBASE

version

varchar(10)

The DBMS version.

See Also

Reference

Replication Views (Transact-SQL)

Concepts

Replication Tables (Transact-SQL)

Other Resources

Heterogeneous Database Replication

Help and Information

Getting SQL Server 2005 Assistance