INF: Understanding Microsoft Repository

Article translations Article translations
Article ID: 238912 - View products that this article applies to.
This article was previously published under Q238912
Expand all | Collapse all

Summary

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:
http://msdn.microsoft.com/en-us/library/aa224785(SQL.80).aspx
Also see "Repository" in SQL Server 7.0 Books Online.

Properties

Article ID: 238912 - Last Review: December 11, 2012 - Revision: 4.0
Applies to
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2000 Standard Edition
Keywords: 
kbarttypeinf kbinfo KB238912

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com