Search This Blog

What happens to the meta information already available on my sql 2000 db while upgrading to SQL 2005

Meta Data Services 3.0 is a component of Microsoft SQL Server 2000 that is no longer available in Microsoft SQL Server 2005. Upgrading does not delete the existing repository tables in the msdb database. However, the repository engine that reads and updates the tables is not available after you upgrade, and the repository tables are no longer accessible. To remove the unused tables, you can manually delete them. Repository tables can be identified by the Rtbl prefix.

No comments: