Cant create diagram of exiting database

SQL server 2005. The database is the SSK database (Shareware application
sample supplied by microsoft) I try to diagram the database and I get an
error message as soon as I click on Diagrams. It says Database support
diagram objects can not be instralled because this database does not have a
valid Owner. To continue first use the files page of the database properties
dialog or ALTER AUTHORIZATION statement to set the database owner to a valid
login, then add database diagram support objects.
I did go in the files page of the database properties dialog and set the
owner to either my current login Mydomain\Myname or to sa. It accepts the
change but it does not make a difference, I keep getting the same message
when I try to use the diagrams on this database. Any other database on this
server, diagrams work fine. Any help in resolving this issue would be
greatly appreciated.
BobYou need to change the compatability level of the database to 90 in order
for diagrams to work.
EXEC sp_dbcmptlevel 'database name', '90'
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Bob" <bdufour@.sgiims.com> wrote in message
news:%23jNEG2CAGHA.1676@.TK2MSFTNGP09.phx.gbl...
> SQL server 2005. The database is the SSK database (Shareware application
> sample supplied by microsoft) I try to diagram the database and I get an
> error message as soon as I click on Diagrams. It says Database support
> diagram objects can not be instralled because this database does not have
> a valid Owner. To continue first use the files page of the database
> properties dialog or ALTER AUTHORIZATION statement to set the database
> owner to a valid login, then add database diagram support objects.
> I did go in the files page of the database properties dialog and set the
> owner to either my current login Mydomain\Myname or to sa. It accepts the
> change but it does not make a difference, I keep getting the same message
> when I try to use the diagrams on this database. Any other database on
> this server, diagrams work fine. Any help in resolving this issue would be
> greatly appreciated.
> Bob
>|||Thanks A LOT, never would have found it by my little old self.
Bob
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:eeUvhJDAGHA.3692@.TK2MSFTNGP10.phx.gbl...
> You need to change the compatability level of the database to 90 in order
> for diagrams to work.
> EXEC sp_dbcmptlevel 'database name', '90'
> --
> HTH
>
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Bob" <bdufour@.sgiims.com> wrote in message
> news:%23jNEG2CAGHA.1676@.TK2MSFTNGP09.phx.gbl...
>