The End Query action will close the connection to the database. You should use this action when you no longer want to use the database within your publication because it will free up memory on your system.
1. Add the End Query action to your trigger, as described in adding actions. The End Query tab will automatically appear when you add the action.
2. Click on the down arrow to the right of the Query box to open a list of query’s you have previously created in this publication.
Note:
If the drop down box is empty, you have not previously entered a Database Query action to this publication. You must have created at least one Database Query action in order for this action to work.
3. Click on the Apply button to save your changes.
Working with Databases - Overview
Introducing the Database Actions