Forum Orisinil

Kategori Umum => Diskusi Umum => Topic started by: irawan on January 27, 2012, 03:40:35 PM

Title: NOLOCK
Post by: irawan on January 27, 2012, 03:40:35 PM

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

[attachment deleted by admin]

Title: Re: NOLOCK
Post by: Yusuf on January 27, 2012, 03:47:49 PM

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

Semoga membantu. thx

Title: Re: NOLOCK
Post by: Budi Santoso on January 27, 2012, 04:10:14 PM

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...

Title: Re: NOLOCK
Post by: irawan on January 27, 2012, 05:00:09 PM

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