关于sp_renamedb
用以下语句给数据库更名时:
EXEC sp_renamedb 'my123', 'myabc'
提示如下错误:
Server: Msg 15228, Level 16, State 1, Procedure sp_renamedb, Line 85
A member of the sysadmin role must set database 'my123' to single user mode with sp_dboption before it can be renamed.
好象要先用sp_dboption
请问在这里还应该如何用sp_dboption?