CheckMyGM and CheckMyC2 can be run in Microsoft SQL Management Studio to check your GoldMine database and SQL server for common problems.
CheckMyGM.SQL - Checks for almost everything I could think of on a SQL server with a GoldMine database. Runs only on a database with both CONTACT files and GMBASE files.
CheckMyC2.SQL - Compares structure of what's defined in CONTUDEF and what currently exists in CONTACT2, and lets you know if there are any potential issues. Run it on a GoldMine database before you try to rebuild your CONTACT2 table to see if you should expect problems.
Naturally you should use these at your own risk. As they sit here, they don't "DO" anything. Just feed you back information. But they may suggest actions for you to take that may irretrievably damage your data. Use at your own risk.
What's New:
CheckMyC2: 10/08/2023 - v1.0.6 - Added check for triggers on CONTACT2 table.
CheckMyGM: 11/08/2023 - v1.0.7 - Add "Find" query to Section: {P}018 {FG}GoldMine-Invalid Data {F}Invalid Record Owner
CheckMyGM: 02/26/2024 - v1.0.8 - Minor tweak to Details column of Section: {P}089 {FG}Performance {F}User created view
- Add [database name] to Details column of Section: {P}004 {FG}Reliability {F}Unusual Database State
- Add Section: {P}039 {FG}GoldMine-Data Problem {F}CONTACT1.CREATEON is NULL
CheckMyGM: 05/28/2025 - v1.0.9 - Add--Section: --Section: {P}059 {FG}GoldMine-Data Problem {F}E-Mail Address begins with a space
CheckMyGM: 09/26/2025 - v1.1.0 - Add rudimentary check for Universal search email compatibility.
CheckMyGM: 09/26/2025 - v1.1.1 - Change Priority for "Open Square Bracket "[" in ACCOUNTNO" from 22 to 35.
