MS SQL

INSERT EXEC failed because the stored procedure altered the schema of the target table.

The Reason behind this error, when you created two temp table with same you will get this error while inserting report from Store Procedure

Solution :

Create table with Different name

Thank You

Leave a Reply

Prabhakaran Jayaraman