Wednesday, January 17, 2018

Change SQL DB from SUSPECT to NORMAL mode

ALTER DATABASE  MicrosoftDynamicsAX  SET  EMERGENCY

DBCC CHECKDB('MicrosoftDynamicsAX')

ALTER DATABASE MicrosoftDynamicsAX SET SINGLE_USER WITH ROLLBACK IMMEDIATE

--Take DB backup,,before running below script.

DBCC CHECKDB (MicrosoftDynamicsAX, REPAIR_ALLOW_DATA_LOSS)


ALTER DATABASE MicrosoftDynamicsAX SET MULTI_USER

No comments:

Post a Comment

Search hierarchy for a match (TableALLGroup) X++

  Table1 ppt;  select firstonly ppt  order ItemCode, ItemRelation, AccountCode, AccountRelation where      (ppt.ItemCode == TableGroupAll::T...