Getting error "Invalid object name . Export is cancelled" when using Export |Create As New Table (4333184)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Getting error "Invalid object name . Export is cancelled" when using Export |Create As New Table
Description

Getting error "Invalid object name . Export is cancelled" when using Export |Create As New Table.
This only happens when the data to export comes from a stored procedure.
If you use the same option with the result of a table or a view it does work.
Resolution

WORKAROUND

Export the result set to a CSV file, then import the CSV file into a new table.

STATUS

Waiting for fix in a future release of Toad for SQL Server
Defect ID

TSS-142

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title