db diagram of SS2000 in SS2005

I have MS SQL Server 2005 Developer Ed. and try to make a database diagram of remote MS SQL Server2000 database in MS SQL Server Management Studio.

I receive an error
"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 diagram support objects."

I googled on this error but all solutions are about databases migrated to SS2005 from SS2000.

Any idea how can I do it in my case (from SS2005 on/to remote SS2000)?

Hi guenavan ,

According to your question, I think the problem should be caused by the invalid owner. That is to say you don't have the permission to operate the remote database via your local MS SQL Server 2005 because the db owner of each side is different. So you may change the owner name of the table on your remote database into the one on your local side first(such as "dbo"). You may try the following T-SQL statement.

sp_changeobjectowner [@.objname=]'object', [@.newowner=]'owner'

More details about the usage of the above statement, pls refterhttp://msdn2.microsoft.com/en-us/library/aa259618(SQL.80).aspx

Thanks.