For procedures scripts which had been renamed from CREATE PROC, TOAD Data Modeler generates a CREATE PROCEDURE <<schema.stored proc name >> statement, with a duplicate CREATE PROC <<schema.stored proc name >> statement directly underneath it. This occurs when code are generated from models which are reverse engineered from SQL Server 2005.
TOAD Data Modeler has problems with procedures of command CREATE PROC. Reverse engineering knows only CREATE PROCEDURE and cannot work with this shortened command.
WORKAROUND:
In the Reverse Engineering Wizard, please select the "Load Some Object as SQL Sentence Only" checkbox.
STATUS:
Waiting for fix in next release of TOAD Data Modeler
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center