- 论坛徽章:
- 0
|
1> sp_configure "allow updates to system tables",1
2> go
Parameter Name Default Memory Used Config Value
Run Value Unit Type
------------------------------ ----------- ----------- ------------
----------- -------------------- ----------
allow updates to system tables 0 0 1
1 switch dynamic
(1 row affected)
Configuration option changed. The SQL Server need not be rebooted since the
option is dynamic.
Changing the value of 'allow updates to system tables' does not increase the
amount of memory Adaptive Server uses.
(return status = 0)
1> update sysdatabases set status=256 where name="cwbase3"
2> go
(1 row affected)
1> dbcc dbrepair(cwbase3,dropdb)
2> go
Msg 2573, Level 16, State 1:
Server 'sybase1', Line 1:
Database 'cwbase3' is not marked suspect. You cannot drop it with DBCC.
DBCC execution completed. If DBCC printed error messages, contact a user with
System Administrator (SA) role.
1> |
|