• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1219
  • Last Modified:

Attach database...

In 2008r2 after copying Northwind.mdf and Northwind_log.ldf to:

C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA

I attempted to attach this database from management studio. I am getting a message in the process stating:

If you are certain that you have added all the necessary full-text catalogs, clcik OK. To add more catalog, click Cancel.  (Please see the attached image)

Q1: Could you please write a line or two about what catalog means here?

Because I am not sure, so when I click OK, the database shows up like:


but I expect it to show just:  NORTHWND

Q2: What action do  I need to take to remedy this?
Q3: Is it possible that this version of NORTHWND.MDF I have is not compatable with 2008R2?

This because I have attached databases before without this kind of issue to deal with.

Thank you.
Mike Eghtebas
Mike Eghtebas
1 Solution

Catalog views return information that is used by the SQL Server Database Engine. We recommend that you use catalog views because they are the most general interface to the catalog metadata and provide the most efficient way to obtain, transform, and present customized forms of this information. All user-available catalog metadata is exposed through catalog views.

Catalog views do not contain information about replication, backup, database maintenance plan, or SQL Server Agent catalog data.

Some catalog views inherit rows from other catalog views. For example, the sys.tables catalog view inherits from the sys.objects catalog view. The sys.objects catalog view is referred to as the base view, and the sys.tables view is called the derived view. The sys.tables catalog view returns the columns that are specific to tables and also all the columns that the sys.objects catalog view returns. The sys.objects catalog view returns rows for objects other than tables, such as stored procedures and views. After a table is created, the metadata for the table is returned in both views. Although the two catalog views return different levels of information about the table, there is only one entry in metadata for this table with one name and one object_id. This can be summarized as follows:

The base view contains a subset of columns and a superset of rows.
The derived view contains a superset of columns and a subset of rows.

You can add those catalogs and clikc OK button.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now