Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
yshie
Starting Member
28 Posts |
 Posted - 2007-03-31 : 05:36:37
|
| i am trying to create a database diagram but this error appears. what does this mean and what should i do? tnxThis database does not have a valid dbo user or you do not have permissionsto impersonate the dbo user, so database diagramming is not available.Ensure the dbo account is valid and ensure that you have impersonatepermission on the dbo account. |
|
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
|
|
yshie
Starting Member
28 Posts |
Posted - 2007-03-31 : 07:02:49
|
| i checked it but its correct. i try to execute sp_helpdb and found out that the owner is incorrect. how will i edit that? |
 |
|
|
yshie
Starting Member
28 Posts |
Posted - 2007-03-31 : 07:43:14
|
| i remembered changing my computer name. and what i see in the dbo owner is the previous computer name. so, how will i change it to current name? |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
database diagram