In this post we will go over a basic Management Reporter Data Mart rebuild for Microsoft Dynamics GP (GP). In my experience a Data Mart (DM) rebuild is a quick way to solve many problems experienced with Management Reporter (MR) and is often my first step. Officially...

Click on the start window at the bottom left of windows and without clicking anywhere else start typing either "Change User Account Control" or "UAC". If you click the windows button then start typing it will automatically search for possible matches within windows....

The below SQL script will search an entire database for a specified value. While it is great for research and trying to find a problematic record, the search time on large databases can become problematic. It can also use a lot of resources so be careful.