INF: Understanding Microsoft Repository

This article was previously published under Q238912
This article has been archived. It is offered "as is" and will no longer be updated.
Microsoft Repository 2.0 is included with Microsoft Visual Studio 6.0 and Microsoft SQL Server 7.0. Microsoft Repository 2.0 uses the Open Information Model (OIM) -- a set of meta data specifications to facilitate sharing and reuse between tools and systems. OIM is a set of open, industry-standard data models that can be shared among software development and data warehousing tools.

In Microsoft SQL Server 2000, the Repository component is called Meta Data Services. SQL Server 2000 installs Repository engine 3.0.

You can preserve any Component Object Model (COM) object in the Repository. In SQL Server 7.0, it is normally used to save Data Transformation Services (DTS) packages with lineage information. When you install Microsoft SQL Server 7.0, the Repository engine is installed by default in the msdb database. A Microsoft SQL Server installation can contain multiple Repositories; however, DTS supports only use a single Repository database for each server in the Microsoft SQL Server Enterprise Manager console tree. This single Repository must reside in the msdb database. The tables that are part of Repository are the tables whose names start with Rtbl, Dbm, Dtm, Dts, Gen, Mds, Ocl, Olp, Tfm, Uml, and Umx. The stored procedures that are part of Repository have names starting with r_i.

The Instmsdb.sql script does not rebuild the repository tables. There is a utility that you can use to rebuild the repository. For additional information about rebuilding the Repository and this utility, click the article number below to view the article in the Microsoft Knowledge Base:
238822 INF: How to Rebuild the Repository in SQL Server 7.0
More information
For more information on the Microsoft Repository, visit the following MSDN Web site:Also see "Repository" in SQL Server 7.0 Books Online.
rep metadata

Article ID: 238912 - Last Review: 12/05/2015 15:28:17 - Revision: 4.0

Microsoft SQL Server 7.0 Standard Edition, Microsoft SQL Server 2000 Standard Edition

  • kbnosurvey kbarchive kbarttypeinf kbinfo KB238912