创建Database Diagrams时遇到的问题
SQL2008 R2中时,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