SQL2005中时,Diagrams的问题

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改一下,再改回去,问题就解决了。
posted on 2007-08-22 10:29  Jack Niu  阅读(367)  评论(0编辑  收藏  举报

Affiliate Marketing and Web Technology