AX Development

Here are the steps to find the Underlying table for the PRIMS           Note: Click on the Images to Enlarge Image 1 rmsDev>GuiDesigner>ProviderTask > Info Boxes Look for the required option (front screen). See image1 Image 2 Select the whole screen; right click to go to the Property Inspector. Select the query option from the drop down list and click on the Underlying query (Image 2)

The transaction log for database   ' X' is full . To find out why space in the   log   cannot be reused, see the log_reuse_wait_desc column in sys.databases.I have encountered this error today while shrinking the databases to free up some space on the servers. This is command I used:  dbcc shrinkdatabase (mydatabase,10) But, as soon I as I ran it, it throws the above error. Solution : The reason for this is that the log file might be FULL. Hence go to     Database Properties &g> Options Then set the recovery model to Simple mode and try shrinking the database again. That should work :)