NOLOCK

[irawan]

tolong agan2.... bantu saya... apa yg terjadi kalau spt ini? mohon pencerahan, karena saya kesulitan menghubungi dealer... thx

[attachment deleted by admin]

[Yusuf]

Bos, coba reindex lagi. Jalanin script yang ada disini: http://forum.orisinil.com/index.php?topic=1547.0

Semoga membantu. thx

[Budi Santoso]

Done...

Langkah yang Saya ambil....

Penanganan Suspect...

Code: [Select]

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

Reindex...

Code: [Select]

USE otomax --Enter the name of the database you want to reindex

DECLARE @TableName varchar(255)

DECLARE TableCursor CURSOR FOR
SELECT table_name FROM information_schema.tables
WHERE table_type = 'base table'

OPEN TableCursor

FETCH NEXT FROM TableCursor INTO @TableName
WHILE @@FETCH_STATUS = 0
BEGIN
DBCC DBREINDEX(@TableName,' ',95)
FETCH NEXT FROM TableCursor INTO @TableName
END

CLOSE TableCursor

DEALLOCATE TableCursor

Shrink...

Alhamdlulillah bisa Done...

[irawan]

thx all... sudah done.... makasi bos salsabila atas bantuannya.... trims juga pak yusuf.... GBU all...