Follow-On Topics

Related Topics

# About the Main Tab

You use the Main tab to configure the database connection for the trigger that activates this task:
|  | Server — This area contains the following for selecting a server which is hosting the required SQL database:
|  | Select Server — Displays a list of all available SQL Servers that have the Microsoft SQL Server Trigger Agent installed for selection.
|  | Select Server Instance — If more than one instance of SQL Server is installed on the selected Server, then they are displayed in the list for selection.
|  | Details — Provides details for the connected SQL Server.
|  | Credentials — This area contains the following for setting the selected server login credentials:
|  | Login Name — A valid login name for connecting to the selected server may be manually entered.
| Click the image to view full size.

|  | Password — A valid password for the selected login name may be manually entered.

|  | Use Trusted Connection — If this option is selected then the currently logged in Users credentials are used to access the selected server. A different User name may be selected to run the Task if this is required to access the required server / database table through the Impersonation tab of the Task Options dialog box.

|  | Select a Table / View — This area contains the following for selecting the required SQL database table or view:

|  | Create Trigger On — Displays the table / column names selected from the SQL database.

|  | Browse — Opens the SQL Server Browser dialog box to enable a SQL database table or view to be selected.

|  | Trigger Order — This area provides the following Fire Trigger options for selection:

|  | First — If SQL server has to fire more than one AFTER trigger for a table change then selecting this option fires this trigger first.

|  | Last — If SQL server has to fire more than one AFTER trigger for a table change then selecting this option fires this trigger last.

|  | No order specified — When SQL server is firing the triggers the position this trigger is fired at is unspecified (Default).

Copyright © 2018 Quadrant Software B.V. All rights reserved.