SQL Server 2012 - SQL Native Client 11 - SQR with Temporary Tables
I was wondering if anyone else has encountered this issue and if so how they resolved it.
We have a set of SQR reports/processes that use SQL Server temporary tables and they are failing in our PT 8.53 upgrade environment. Here is the log messages:
SQL Status = 11525, SQL Error = [Microsoft] [SQL Server Native Client 11.0] [SQL Server] The metadata could not be determined because statement 'SELECT.......' uses a temp table.
The PT 8.53 upgrade environment is using SQL Server 2012 and the SQL Server Native Client 11.0 driver. When I run the process in SQL Server 2008 with the SQL Server Native Client 10 driver OR in using SQRW from my workstation connecting to SQL Server 2012 with SQL Server Native Client 10.0 driver the error does not present itself and the process runs to success.