Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Error message in Microsoft Dynamics GP: “Stored Procedure XXXX returned the following results. DBMS: 12, Microsoft Dynamics GP: 0"

Error message in Microsoft Dynamics GP: “Stored Procedure XXXX returned the following results. DBMS: 12, Microsoft Dynamics GP: 0"

View products that this article applies to.

Symptoms

In Microsoft Dynamics GP, you receive the following error message:

Stored Procedure XXXX returned the following results. DBMS: 12, Microsoft Dynamics GP: 0


Note XXXX is a placeholder for the name of a stored procedure.

↑ Back to the top

Cause

This problem occurs if a temporary table cannot be created correctly on the server that is running Microsoft SQL Server.

↑ Back to the top

Resolution

To resolve this problem, follow these steps:

  1. Have all users exit Microsoft Dynamics GP.
  2. Stop the SQL Server service, and then start the SQL Server service to clear the temporary tables in the tempdb database. To do this , follow these steps:
    • If you use SQL Server Management Studio, follow these steps:

      1. Click Start, point to All Programs, point to Microsoft SQL Server 2005 or 2008, and then click SQL Server Management Studio.
      2. In the Connect to Server window, follow these steps:

        1. In the Server name box, type the name of the server that is running SQL Server.

        2. In the Authentication box, click SQL Authentication.
        3. In the Login box, type sa.

        4. In the Password box, type the password for the sa user, and then click Connect.

      3. In the Object Explorer pane, right-click the appropriate instance of SQL Server, and then click Stop.
      4. Right-click the appropriate instance of SQL Server again, and then click Start.

    • If you use SQL Server Enterprise Manager, follow these steps:

      1. Click Start, point to All Programs, point to Microsoft SQL Server, and then click Enterprise Manager.
      2. Right-click the appropriate instance of SQL Server, and then click Stop.

      3. Right-click the appropriate instance of SQL Server again, and then click Start.

    • If you do not have SQL Server Management Studio or SQL Server Enterprise Manager, follow these steps:

      1. Click Start, click Run and then type services.msc.
      2. Click the appropriate instance of SQL Server, and then click Stop.

      3. Right-click the appropriate instance of SQL Server again, and then click Start.
Notes
  • Microsoft Dynamics GP 2010 is not supported with SQL Server 2000.
  • Microsoft Dynamics GP 9.0 is not supported with SQL Server 2008.

↑ Back to the top

Keywords: kbmbsmigrate, kbmbspartner, kbprb, kbfreshness2007, kbmbsgp10,, kbtshoot, kb, kbexpertiseadvanced, kbexpertisebeginner, kbexpertiseinter, kberrmsg

↑ Back to the top

Article Info
Article ID : 852594
Revision : 3
Created on : 3/30/2017
Published on : 3/30/2017
Exists online : False
Views : 199