Get "Error (S0002, D0)...[SQL Server][Invalid object name...]" quering temp table (4244723)

Converse agora com nosso suporte

Voltar

Feedback enviado

Este artigo resolveu um problema para você?

Selecione a classificação

Título

Get "Error (S0002, D0)...[SQL Server][Invalid object name...]" quering temp table
Descrição

The following error is returned, when executing SQL that queries a temp table. The SQL runs fine outside of BMF.

Error (S0002, D0) – [Microsoft][SQL Server Native Client 11.0 ][SQL Server][Invalid object name ‘TABLE_NAME’.
Causa

The issue is due to the scope of the temporary table that is created and how BMF does the transactions. Temporary tables are only visible to the user session or stored procedure/function that creates them. BMF prepares and then executes the SQL and if the prepared statement is not called again, the statement is dropped. This causes the temporary table to go out of scope and become not visible to the next transaction.
Resolução

WORKAROUND:
None

STATUS:
This issue is fixed in Benchmark Factory 8.2. This version can be downloaded from the downloads section of our website, which you can access by clicking here.
ID do defeito

BMF-5148

Feedback enviado

Este artigo resolveu um problema para você?

Selecione a classificação

Conteúdo recomendado

Título