Notes:
To reset a sequence
Select a sequence and click to reset a sequence.
Note: MAXVALUE, MINVALUE, INCREMENT BY and CYCLE properties can be altered in the Editor only.
Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.
To create or alter trigger
Select one of the following:
Note: You can change how objects display in the Object Explorer. For example, you can create custom categories or move objects out of existing categories (such as Programmability and Security) in Tools | Options | Explorer | Objects. See Object Options for more information.
Select on of the following:
Complete the fields as necessary. Review the following for additional information:
General |
Description |
Execute trigger |
Select one of the following options:
|
Execution Context |
Description |
Use |
Select whether to specify user context when executing the trigger. |
User |
Select a user context for the trigger. |
Settings |
Description |
Encrypt text |
Select whether to encrypt any syscomments entries containing text from the trigger. |
Not for replication |
Select whether to stop the trigger from executing if a replication modifies a table included in the trigger. |
To enable or disable a trigger
Right-click a table and select View Details.
Select the Triggers tab in the Viewer pane.
Select one or more triggers.
Click or
.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité Cookie Preference Center