--查询数据库状态 SELECT DATABASEPROPERTYEX(' DBName','STATUS') --设置DBName在线 alter database DBName set online --设置DBName离线 alter database DBName set offline
转自:http://www.mossfly.com/set-sql-server-status.html
--SQL SERVER
--查询数据库状态 SELECT DATABASEPROPERTYEX(' DBName','STATUS') --设置DBName在线 alter database DBName set online --设置DBName离线 alter database DBName set offline
转自:http://www.mossfly.com/set-sql-server-status.html
--SQL SERVER