我用exec sp_renamedb 't','newname'修改数据库名字
产生了以下错误,请问如何解决,谢谢!Server: Msg 15228, Level 16, State 1, Line 0
A member of the sysadmin role must set database 't' to single user mode with sp_dboption before it can be renamed.
产生了以下错误,请问如何解决,谢谢!Server: Msg 15228, Level 16, State 1, Line 0
A member of the sysadmin role must set database 't' to single user mode with sp_dboption before it can be renamed.
你要先用sp_dboption 将你的数据库t改为单用户模式,然后再执行你的这个命令。