“The stored procedure createSQLTmpTable returned the following results: DBMS: 12” exceptions

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Many of inquiry windows in Microsoft Dynamics GP have been optimized to leverage SQL Server to increase performance. This is especially common with transaction inquiry windows which can combine data from more than one table (ie. Work, Open and History).

