SAP Knowledge Base Article - Preview

1286838 - Error “Connection or SQL Sentence error: (DA0005) Exception: DBD, [Microsoft SQL Native Client]: Invalid object name #table name. State: 42S02” using Free Hand SQL in Desktop Intelligence

Symptom

  • Unable to create Free Hand SQL report using temporary tables from tempdb database
  • Error: "Connection or SQL Sentence error: (DA0005) Exception: DBD, [Microsoft SQL Native Client]: Invalid object name #table name. State: 42S02" is displayed when we try to execute a small select query.


Read more...

Product

SAP BusinessObjects Business Intelligence platform R2

Keywords

Stored Procedures, DeskI, Query, Language, SQL a la carte , KBA , BI-BIP-SL , Semantic Layer , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.