--ms sql server 7、ms sql server 2000 use master go exec sp_dboption 'test','single user','on' go exec sp_renamedb 'test','test1' go exec sp_dboption 'test1','single user','off' go--在ms sql server 2000中,推荐使用 ALTER DATABASE 设置数据库选项 use master go alter database test1 set SINGLE_USER go exec sp_renamedb 'test1','test' go alter database test set MULTI_USER go
use master
go
exec sp_dboption 'test','single user','on'
go
exec sp_renamedb 'test','test1'
go
exec sp_dboption 'test1','single user','off'
go--在ms sql server 2000中,推荐使用 ALTER DATABASE 设置数据库选项
use master
go
alter database test1 set SINGLE_USER
go
exec sp_renamedb 'test1','test'
go
alter database test set MULTI_USER
go