A. ½«Êý¾Ý¿âÉèÖÃΪֻ¶Á
ÏÂÃæµÄʾÀý½« pubs Êý¾Ý¿âÉèÖÃΪֻ¶Á¡£
USE master
EXEC sp_dboption 'pubs', 'read only', 'TRUE'
ÏÂÃæÊǽá¹û¼¯£º
CHECKPOINTing database that was changed.
B. ¹Ø±ÕÑ¡Ïî
ÏÂÃæµÄʾÀý½« pubs Êý¾Ý¿âÖØÐÂÉèÖÃΪ¿Éд¡£
USE master
EXEC sp_dboption 'pubs', 'read only', 'FALSE'
ÏÂÃæÊǽá¹û¼¯£º
CHECKPOINTing database that was changed.
C. ʹÊý¾Ý¿âÍÑ»ú
ÏÂÃæµÄʾÀýʹÊý¾Ý¿â sales ÔÚûÓÐÓû§·ÃÎÊʱ½øÈëÍÑ»ú״̬¡£
USE master
EXEC sp_dboption 'sales', 'offline', 'TRUE'