tanda ' nya coba bos hapus, ketik ulang...
pakai ini
EXEC sp_resetstatus ‘otomax’;
ALTER DATABASE otomax SET EMERGENCY
DBCC checkdb(‘otomax’)
ALTER DATABASE otomax SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB (‘otomax’, REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE otomax SET MULTI_USER
hasilnya :
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '‘'.
Msg 102, Level 15, State 1, Line 3
Incorrect syntax near '‘'.
Msg 102, Level 15, State 1, Line 5
Incorrect syntax near '‘'.
saya udah coba hapus '
EXEC sp_resetstatus otomax;
ALTER DATABASE otomax SET EMERGENCY
BCC checkdb(otomax)
ALTER DATABASE otomax SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB (otomax, REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE otomax SET MULTI_USER
hasilnya
Msg 102, Level 15, State 6, Line 3
Incorrect syntax near 'checkdb'.