CRM Organization Import Could not find stored procedure p_CreateAuditEntry

During our DEV server builds we came across a bug during an import of CRM Organizations. When we would try to import a refresh of production to DEV we received the following error in the Install log.

Could not find stored procedure p_CreateAuditEntry

After some testing we figured out that this error happens when you try to restore a second copy of production on the same DEV machine as a different organization. We wanted multiple organizations on our DEV server to test different upgrades and such. The first copy of production would import just fine. However when we tried to refresh a second copy of prod into a different organization we would hit this error.

The fix is pretty simple, however you cannot run this fix in a production CRM envrionment. Running the fix will void your warranty with Microsoft because we are modifying the MSCRM_CONFIG database.

DO NOT RUN THIS IN YOUR PRODUCTION ENVIRONMENT EVER.

Connect to your MSCRM_CONFIG Database using SQL Server Management Studio and execute the script below.

Now you can try to import your organization again and it should no longer give you an error.