Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Azure Property Editors › SQL Azure Database Support in CA ERwin Data Modeler › Stored Procedure Properties

Stored Procedure Properties

The following describes new or changed properties in the property editor and related information.

• SQL Azure does not support the following arguments and options with the CREATE PROCEDURE statement:
  • FOR REPLICATION
  • EXTERNAL NAME (external methods)
  • ENCRYPTION

The following describes the impacts on the SQL Azure Stored Procedure Editor as compared to the SQL Server 2008 Stored Procedure Editor:

• On the General tab, the Assembly option was removed from Code Type drop-down, and the For Replication and Encryption options are unavailable.