Attaching Northwind (2000) into SQL Server 2005

I am trying to attach to the SQL Server 2000 sample Northwind database using SQL Server 2005. When I do the Database-->Attach using the GUI everything seems alright. I can open the Northwind database and see the usual listing of stuff.

However, when I click on the Database Diagrams, I get an error message stating "Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database support objects."

I have tried repeatedly to get the ALTER AUTHORIZATION statement to work, all to no avail. I have restarted my machine, and the properties of the database is now saying that the owner is the same as the other databases I have, but I keep getting the error message.

What am I doing wrong here? How can I fix this?

Any help would be greatly appreciated.

Thank you.Did you already checked the link: http://msdn2.microsoft.com/en-us/library/ms186345.aspx

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

That worked perfectly.

Thank you!

Attached Northwind to SQL Express but no data in tables

I installed Northwind sample database by running the install script within server management sudio express and the database and tables show up, but there are no records. Once executed, it says it was successful.

Am I missing something?

The data is there. I had built some code to extract the customer data to a datagrid and it was only pulling the column headers and no data. I opened the managment studio and asked it to open a table and the records were there. Sorry for the post.