Microsoft KB Archive/238912

= INF: Understanding Microsoft Repository =

Article ID: 238912

Article Last Modified on 10/31/2003

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q238912



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

There is also a Software Developer's Kit (SDK) available for the repository. You can download this SDK from the following Web site:

http://msdn.microsoft.com/downloads/default.asp?URL=/code/sample.asp?url=/msdn-files/027/001/475/msdncompositedoc.xml&FinishURL=%2Fdownloads%2Frelease%2Easp%3FReleaseID%3D25541%26redirect%3Dno

The most recent version of the Microsoft Repository SDK is 2.1b.



MORE INFORMATION
For more information on the Microsoft Repository, visit the following MSDN Web site:

http://msdn.microsoft.com/repository/default.asp

Also see "Repository" in SQL Server 7.0 Books Online.

Additional query words: rep metadata

Keywords: kbinfo kbarttypeinf KB238912

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.