www.oto.pelangi.co.id

  • Increase font size
  • Default font size
  • Decrease font size

Transaksi tidak mau sukses otomatis

E-mail Print PDF

1. // Menghapus Triger
DROP TABLE [dbo].[temp_connector]
DROP TRIGGER [dbo].[trgTransaksi]

2. // Menghapus modul
Delete from  dbo.modul where deleted = 1
Delete from  dbo.sms_center where deleted = 1
Delete from  dbo.sms_sender where deleted = 1
Delete from  dbo.terminal where deleted = 1

3. // Menghapus Komisi yg sudah di tukar
DELETE FROM komisi where tukar='1'

4 //Reindex Database
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

5. //Terahir shrink DATABASE




thansk to SC RELOAD

Supported by www.Pelangi.co.id