demo032.sql

T-SQL示例大全

/* 文件名称: Demo032.sql */
USE master
GO

EXEC sp_dboption @dbname =  'MyDb',
                              @optname = 'offline' ,
                              @optvalue =  'true'  

EXEC sp_dboption @dbname =  'MyDb',
                              @optname = 'offline' ,
                              @optvalue =  'false'