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.