Showing posts with label DBA. Show all posts
Showing posts with label DBA. Show all posts

Thursday, October 31, 2024

็How to repair table script sql by dbcc checktable

 USE KMx10

GO

ALTER DATABASE KMx10 SET SINGLE_USER WITH ROLLBACK IMMEDIATE;

GO

DBCC CHECKTABLE (N'job',REPAIR_REBUILD) WITH NO_INFOMSGS, ALL_ERRORMSGS;

GO

ALTER DATABASE KMx10 SET MULTI_USER;

Infor SyteLine (CSI) customize Custom Assembly

  if you are looking for script to test run Infor CSI Custom Assembly you can use below code. using System; using System.Collections.Generic...