SQL2005中时，Diagrams的问题

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.

 

解决方法：

1. 右键点击数据库，选“properties ”
2. 点选左侧“Options” 
3. 在'Compatibility Level' 选 'SQL Server 2005(90)'
4. 点选左侧“Files”
5. 在owner里填入 'sa' 
6. OK

-----

说明，主要是owner的问题，不要管它的提示，可能把owner改一下，再改回去，问题就解决了。