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

Trigger Properties

SQL Azure does not support the following arguments and options with the CREATE TRIGGER statement:

• ENCRYPTION
• WITH APPEND
• NOT FOR REPLICATION
• EXTERNAL NAME option (there is no external method support)
• ALL SERVER Option (DDL Trigger)
• Trigger on a LOGON event (Logon Trigger)

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

• In the General tab, the properties Encryption Enabled and Not for replication are unavailable
• In the Code tab, Assembly is unavailable from the Type drop-down and CLR options are unavailable

The impacts to reverse-engineer from script include:

• With append is not allowed in a CREATE or ALTER clause
• CREATE TRIGGER XX ON ALL SERVER is not allowed
• Creation of a LOGON trigger is not allowed