SS2000 database diagram from SS2005

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

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)?

[1296 byte] By [GuennadiiVanine] at [2008-1-3]

«« Iterations's Scope
»» Outlook suggestion

# 1

right click on the database select properties -- you will get "Database PRoperties" window Select Files and mention the Owner for this database

Madhu

MadhuKNair at 2007-9-25 >

top of Msdn Tech,SQL Server,SQL Server Tools General...

# 2

But I can mark only local users and that database is on another PC.
Also we do not have domain but workgroup
(well, for some reason I even do not see on a network the machine where SS2000 database is located.
But I connect to that database through account assigned locally in that SS2000)

GuennadiiVanine at 2007-9-25 >

# 3

Management Studio 2005 does not support database diagrams on SQL Server 2000. The 2005 implementation requires security features that are not present on previous versions.

Thanks,

Steve

StevenTwitchell-MSFT at 2007-9-25 >

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

it's Archive about 'SS2000 database diagram from SS2005...'

SS2000 database diagram from SS2005

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Site Classified