Generate Script Ins/Upd SP Syntax Issue

[papker]

I tried the option "Generate Script As" - "Insert/Update Stored Procedure" and noticed it is generating with a syntax problem.

The table name is "Communications" and so the SP name that it generates is "communications_IU" which is fine, however the update statement uses the SP name instead of the table name in the query.

eg.

Code: Select all

IF EXISTS
  (SELECT * FROM dbo.communications WHERE Pk = @Pk)
    UPDATE communications_IU SET
      Direction = ....

should be .....

Code: Select all

IF EXISTS
  (SELECT * FROM dbo.communications WHERE Pk = @Pk)
    UPDATE communications SET
      Direction = ....

version 5.4.215

[alexa]

We will fix this issue in one of the next product builds and will notify you once it's available for downloading.