March 22, 2010 at 9:38 am
hello
i want to c the relation ship diagram of the northwined database
where to go
tnx
March 22, 2010 at 10:00 am
Have you tried the Database Diagrams tab under the database name in Management Studio?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 22, 2010 at 10:42 am
int the database diagram i get these messega
TITLE: Microsoft SQL Server Management Studio
------------------------------
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.
------------------------------
BUTTONS:
OK
------------------------------
March 23, 2010 at 6:27 am
You need to set the database owner, like the error message says. Follow the directions you copied here and you'll get what you need.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 23, 2010 at 6:29 am
adnan.fast (3/22/2010)
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.
If you check in SSMS, you will see the database does not currently have an owner, or that owner is not correctly associated with a valid login. To fix this, assign a valid owner (as the error message suggests). The T-SQL to do this is:
ALTER AUTHORIZATION ON Database::Northwind TO sa;
Of course, you may want to assign ownership to a login other than sa...up to you.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply