Note Before you follow the instructions in this article, make sure that you have a complete backup copy of the database that you can restore if a problem occurs. 1. Open SQL Server Management Studio using the appropriate method below:
- If you are using Microsoft SQL Server 2005, click Start, point to All Programs, point to Microsoft SQL Server 2005 and then click SQL Server Management Studio. To open a query window, click on the New Query button at the top.
- If you are using Microsoft SQL Server 2008 or Microsoft SQL Server 2008 R2, click Start, point to All Programs, point to Microsoft SQL Server 2008 or Microsoft SQL Server 2008 R2 and then click on SQL Server Management Studio. To open a query window, click on the New Query button at the top.
2. Select the company database using the drop-down list.
3. Run the following script to delete the FAINDEX table. (This table will automatically rebuild itself.)
4. Test again.
5. If this does not resolve the problem, then have all users exit Microsoft Dynamics GP. Make a current backup, and then run these scripts against the company database:
Delete Dynamics..ACTIVITY --all users should be out of GP before running
Delete Dynamics..SY00800
Delete Dynamics..SY00801
Delete TEMPDB..Dex_Session
Delete TEMPDB..Dex_Lock
Delete FAINDEX
Delete FA01500