Back

Deleting a GP Real Time Trigger in SmartConnect

Published: Dec 08, 2011
Post Author Written by Kevin Jones

How to delete a real time GP trigger.


If you have a GP Real Time Table Trigger that you would like to remove, you need to delete it from the SQL tables directly. Here are the steps for this operation:

1. Open up SQL Query Analyzer on your SQL server.

2. Choose to create a new query.

3. Run the following query in your DYNAMICS database

Select TABLDESC,* from SC30100

4. Look through the results to determine which trigger you are trying to remove. The TABLDESC field will have the same name as the trigger you created.

5. In order to remove it, run the following statement against your DYNAMICS database

DELETE SC30100 where TABLDESC=’XXX’

DELETE SC30101 where TABLDESC=’XXX’

DELETE SC30102 where TABLDESC=’XXX’
DELETE SC30103 where TABLDESC=’XXX’
DELETE SC30104 where TABLDESC=’XXX’
Replace XXX with the actual table description of the trigger you are trying to delete. So if you TABLEDESC is called Payroll Master, then your SQL statement will look like this
DELETE SC30100 where TABLDESC=’Payroll Master’
DELETE SC30101 where TABLDESC=’Payroll Master’

DELETE SC30102 where TABLDESC=’Payroll Master’
DELETE SC30103 where TABLDESC=’Payroll Master’
DELETE SC30104 where TABLDESC=’Payroll Master’
6. In order for the trigger to be completely removed, everyone will need to log out of Great Plains and log back in again.

Did this answer your question?

FEEDBACK FORM HERE

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

We're on your integration team. Connect with our people and let us know how we can help you.