Post reply

MetaData

  • January 23, 2004 at 9:37 am

    #84367

    I can only browse data.  I need to delete data.  From BOL:

    "In SQL Server, Meta Data Services provides storage service for SQL Server meta data, including meta data associated with specific Data Transformation Services (DTS) packages and all online analytical processing (OLAP) meta data. Repository tables are included in the SQL Server msdb system database to support management and storage of SQL Server meta data.

    In SQL Server Enterprise Manager, Meta Data Browser enables you to view meta data that you create and store in msdb. You can view this data in the Contents folder.

    When you use Meta Data Browser in SQL Server Enterprise Manager, you function in End User mode. End User Mode provides read-only access to the repository database. You can view information about any meta data that you store in the repository.

    SQL Server Enterprise Manager purposely restricts the functionality of Meta Data Browser to protect the meta data that it uses. Modifying or deleting native meta data can corrupt your SQL Server installation. For this reason, actions that put your meta data at risk are not supported in this mode.

    Running Meta Data Browser Separately

    Meta Data Services can be run separately from SQL Server Enterprise Manager as a stand-alone MMC snap-in. You can add Meta Data Services to a console to work with other SQL Server repository databases, using a wider range of functionality.

    After you add Meta Data Services to the MMC, you can run the Meta Data Browser to register the repository databases you want to work with. You can work with any SQL Server repository database created in SQL Server version 6.5 or 7.0, or in SQL Server 2000. However, you must use version 3.0 of the repository engine that is distributed with SQL Server 2000.

    To run the browser in stand-alone mode, click Meta Data Services.

    "

    What does this last statement mean?  "Click Meta Data Services"  Where do I find this?  How do I add Meta Data Services to the MMC?  When I click Meta Data under the DTS folder in EM I can browse some databases.  I want to delete these.  Does someone know how?

    Francis

  • January 23, 2004 at 10:05 am

    #491412

    I do not believe you can delete Meta Data Services from the EM snap in. Not sure it's a good idea. Why do you want to delete this?

    you can right click the Meta Data Serivces and choose New Window and it will be a standalong.

     

  • January 23, 2004 at 10:13 am

    #491419

    I want to delete it because I was experimenting with adding a DTS package on a production server and using my local sever as a destination.  The package was added, but I cannot delete it, just browse it (even when logged on as 'sa')  I don't want to leave this on the production box.  I used the production box since it wasn't woking on my local machine.  I thought I could just save the package then delete it.

    I don't understand your post.  "you can right click the Meta Data Serivces and choose New Window "  I don't have anything that says Meta Data Services.   Under the DTS folder I have Meta Data Services Packages, but when I right click on this I don't get a New Window Option in the drop down.  Please clarify.

    Francis

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply