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;
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;
Balance is not equal to 0 for Journal that has [Journal: SF Dist] select * from wc_mst where outside is null --update wc_mst set outside =...