SQL 2005 建立数据库图表时出现以下错误Database diagram support objects cannot be installed because this database does not have a valid owner 解决
来源:互联网 发布:ios cell数组赋值 编辑:程序博客网 时间:2024/04/28 08:20
在SQL2005中建立数据库图表时出现以下错误:
"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."
分条执行以下语句:
EXEC sp_dbcmptlevel '数据库名', '90';
go
ALTER AUTHORIZATION ON DATABASE::数据库名 TO "当前登陆用户名"
go
use [数据库名]
go
EXECUTE AS USER = N'dbo' REVERT
go
eg:
EXEC sp_dbcmptlevel 'idr_history_rdb', '90';
go
ALTER AUTHORIZATION ON DATABASE::idr_history_rdb TO "sa"
go
use [idr_history_rdb]
go
EXECUTE AS USER = N'dbo' REVERT
go
手动修改:
1. 右键点击数据库,选“properties ”
2. 点选左侧“Options”, 在'Compatibility Level' 选 'SQL Server 2005(90)'
3. 点选左侧“Files”, 在owner里填入 'sa'
4. OK
- SQL 2005 建立数据库图表时出现以下错误Database diagram support objects cannot be installed because this database does not have a valid owner 解决
- Database diagram support objects cannot be installed because this database does not have a valid owner.
- Database diagram support objects cannot be installed because this database does not have a valid own
- Database diagram ...... dose not have a valid owner.解决方法
- this database does not have a valid owner 的解决办法--【叶子】
- this database does not have a valid owner 的解决办法--【叶子】
- VS2010 + Sql Server Express 2008 R2 如何安装(兼谈错误:The database 'XXX' cannot be opened because it is version 661. This server support
- HPDDL0017E This database does not contain a valid header
- SQL恢复备份遇到错误 - his differential backup cannot be restored because the database has not been restored
- 安装concrete时提示“...database does not support InnoDB database tables..."如何解决
- mvc3.0 报错Model compatibility cannot be checked because the database does not contain model metadata
- SqlServer2005 恢复数据库时出现Exclusive access could not be obtained because the database is in use 的解决方法
- SqlServer2005 恢复数据库时出现Exclusive access could not be obtained because the database is in use 的解决方法
- SqlServer2005 恢复数据库时出现Exclusive access could not be obtained because the database is in use 的解决方法
- openfire 安装配置报错The Openfire database schema does not appear to be installed. Follow the installati解决
- openfire 安装配置报错The Openfire database schema does not appear to be installed. Follow the installati解决
- Web Service调用Nhibernate数据访问异常:xx cannot be serialized because it does not have a parameterless constructor
- Web Service调用Nhibernate数据访问异常:xx cannot be serialized because it does not have a parameterless constructor
- C# 生产新闻文章分页
- 互联网应用软件系统架构模式的确立
- 给2000/xp/2003独立安装iis
- hibernate 方言
- Eclipse 中经常用到的快捷键
- SQL 2005 建立数据库图表时出现以下错误Database diagram support objects cannot be installed because this database does not have a valid owner 解决
- 修复print spooler
- 自动发博 - 参考代码
- fghfghfghfghfg
- Linux系统共享库编程
- 今天的我
- 如何释放Sqlserver所占得内存
- Java游戏中延迟下载资源及调用示例
- VC++ textlist的滚动条自动滚到底端