Invalid Object Name Error

Description

When you add a stored procedure to a data model, you receive an invalid object name error message.

Cause

Your stored procedure contains a temporary table. Due to a product limitation, you cannot use stored procedures with temporary tables in data models.

Affected Versions

7.0 and later.

Solution

Use a table variable. For more information, read this article.

About this Article
  • Created: 06/18/2017 5:45 am EDT
  • Last updated: 06/18/2017 5:54 am EDT
In This Article