Enabling a Trigger in Microsoft SQL Server Management Studio
By enabling triggers that track changes are turned on or off for these tables. Most of these tables have a delete trigger with a name in the format of ‘XXXX_D_CDC’ where XXXX is the table name and an insert/update trigger in the form of ‘XXXX_IU_CDC’. Two tables make an exception to this rule and have 3 triggers, one for Insert, one for update and one for delete. They are tables SV00300 and SV00301.
To enable a trigger in Microsoft SQL Server Management Studio:
- Launch Microsoft SQL Server Management Studio.
- Expand Databases > your company database > Tables.
- Expand the appropriate table.
- Expand Triggers.
- Right-click on the XXXX_D_CDC trigger and select Enable. (This is the "delete" trigger.)
- Right-click on the XXXX_IU_CDC trigger and select Enable. (This is the "insert/update" trigger.)
Enabled Triggers Script
This script provides a list of all enabled scripts for a given company:
|
Enabled Triggers Query Results
These are the results of the enabled triggers script query, assuming all nine triggers are enabled. Note that the Entity name does not display in the query results.
| Entity | Trigger Name | Table Name | Disabled |
|---|---|---|---|
| Job | JC00102_D_CDC | JC00102 | 0 |
JC00102_IU_CDC | JC00102 | 0 | |
| Job Cost Code | JC00701_D_CDC | JC00701 | 0 |
JC00701_IU_CDC | JC00701 | 0 | |
| GP Customer | RM00101_D_CDC | RM00101 | 0 |
RM00101_IU_CDC | RM00101 | 0 | |
| Technician | SV00115_D_CDC | SV00115 | 0 |
SV00115_IU_CDC | SV00115 | 0 | |
Service Option | sv00196_D_CDC | sv00196 | 0 |
sv00196_IU_CDC | sv00196 | 0 | |
Location | SV00200_D_CDC | SV00200 | 0 |
SV00200_IU_CDC | SV00200 | 0 | |
| Service Call | SV00300_D_CDC | SV00300 | 0 |
SV00300_I_CDC | SV00300 | 0 | |
SV00300_U_CDC | SV00300 | 0 | |
| Appointment | SV00301_D_CDC | SV00301 | 0 |
SV00301_I_CDC | SV00301 | 0 | |
SV00301_U_CDC | SV00301 | 0 | |
| Equipment | SV00400_D_CDC | SV00400 | 0 |
SV00400_IU_CDC | SV00400 | 0 |
Disabled Triggers Script
If you need to enable triggers for a table not found in this list, run the following script to find the triggers for a given table not in the list and then go through Microsoft SQL Server Management Studio and manually enable the trigger:
|
Disabled Triggers Query Results
GP Database Level
These are the query results at the GP database level from the disabled triggers script. Note that the Entity name does not display in the query results.
| Entity | Trigger Name | Table Name | Disabled |
|---|---|---|---|
| Call Source | SVCALLSRC_D_CDC | SVCALSRC | 1 |
| SVCALLSRC_IU_CDC | SVVALSRC | 1 | |
| GP Company | SY01500_D_CDC | SY01500 | 1 |
| SY01500_IU_CDC | SY01500 | 1 |
Company Database Level
These are the query results at the Company database level from the disabled triggers script, assuming the default nine triggers have been enabled. Note that the Entity name does not display in the query results.
| Entity | Trigger Name | Table Name | Disabled |
|---|---|---|---|
| GP GL Account | GL00100_D_CDC | GL00100 | 1 |
GL00100_IU_CDC | GL00100 | 1 | |
Job User Defined | JC00107_D_CDC | JC00107 | 1 |
JC00107_IU_CDC | JC00107 | 1 | |
| Estimate Revision | JC00201_D_CDC | JC00201 | 1 |
JC00201_IU_CDC | JC00201 | 1 | |
| Forecast Revision | JC00401_D_CDC | JC00401 | 1 |
JC00401_IU_CDC | JC00401 | 1 | |
| Job Cost Note | JC00501_D_CDC | JC00501 | 1 |
JC00501_IU_CDC | JC00501 | 1 | |
| Job Bill Code | JC00601_D_CDC | JC00601 | 1 |
JC00601_IU_CDC | JC00601 | 1 | |
| Job Revenue Code | JC00610_D_CDC | JC00610 | 1 |
JC00610_IU_CDC | JC00610 | 1 | |
| Employee Union Code Master | JC00801_D_CDC | JC00801 | 1 |
JC00801_IU_CDC | JC00801 | 1 | |
Change Order | JC01001_D_CDC | JC01001 | 1 |
JC01001_IU_CDC | JC01001 | 1 | |
| Change Order Cost Code | JC01002_D_CDC | JC01002 | 1 |
JC01002_IU_CDC | JC01002 | 1 | |
| Job Change Order Revenue Code | JC01004_D_CDC | JC01004 | 1 |
JC01004_IU_CDC | JC01004 | 1 | |
| Job Vendor | JC01501_D_CDC | JC01501 | 1 |
JC01501_IU_CDC | JC01501 | 1 | |
| Job Vendor Date | JC01504_D_CDC | JC01504 | 1 |
JC01504_IU_CDC | JC01504 | 1 | |
| Job Project | JC01701_D_CDC | JC01701 | 1 |
JC01701_IU_CDC | JC01701 | 1 | |
| Rate Class | JC01801_D_CDC | JC01801 | 1 |
JC01801_IU_CDC | JC01801 | 1 | |
| Job Lien Waiver | JC20705_D_CDC | JC20705 | 1 |
JC20705_IU_CDC | JC20705 | 1 | |
| Fed Class | JC40106_D_CDC | JC40106 | 1 |
JC40106_IU_CDC | JC40106 | 1 | |
| Union Code | JC40201_D_CDC | JC40201 | 1 |
JC40201_IU_CDC | JC40201 | 1 | |
| Cost Element | JC40209_IU_CDC | JC40209 | 1 |
| Resource Extension | K2A_ResourceExtension_D_CDC | K2A_ResourceExtension | 1 |
K2A_ResourceExtension_IU_CDC | K2A_ResourceExtension | 1 | |
| GP Purchase Order | POP10100_D_CDC | POP10100 | 1 |
POP10100_IU_CDC | POP10100 | 1 | |
| GP Purchase Order Detail | POP10110_D_CDC | POP10110 | 1 |
POP10110_IU_CDC | POP10110 | 1 | |
| GP Address | RM00102_D_CDC | RM00102 | 1 |
RM00102_IU_CDC | RM00102 | 1 | |
| GP Salesperson | RM00301_D_CDC | RM00301 | 1 |
RM00301_IU_CDC | RM00301 | 1 | |
| Installation By | SV_00415_D_CDC | SV_00415 | 1 |
SV_00415_IU_CDC | SV_00415 | 1 | |
| Time Zone | SV00045_D_CDC | SV00045 | 1 |
SV00045_IU_CDC | SV00045 | 1 | |
| Division | SV00077_D_CDC | SV00077 | 1 |
SV00077_IU_CDC | SV00077 | 1 | |
| Note | SV000805_D_CDC | SV000805 | 1 |
SV000805_IU_CDC | SV000805 | 1 | |
| Customer | SV00100_D_CDC | SV00100 | 1 |
SV00100_IU_CDC | SV00100 | 1 | |
| Technician Vehicle | SV00113_D_CDC | SV00113 | 1 |
SV00113_IU_CDC | SV00113 | 1 | |
| Technician Branch | SV00114_D_CDC | SV00114 | 1 |
SV00114_IU_CDC | SV00114 | 1 | |
| Technician Skill Set | SV00155_D_CDC | SV00155 | 1 |
SV00155_IU_CDC | SV00155 | 1 | |
| Sublocation | SV00201_D_CDC | SV00201 | 1 |
SV00201_IU_CDC | SV00201 | 1 | |
| Problem Type | SV00310_D_CDC | SV00310 | 1 |
SV00310_IU_CDC | SV00310 | 1 | |
| Call Type | SV00320_D_CDC | SV00320 | 1 |
SV00320_IU_CDC | SV00320 | 1 | |
| Appointment Status | SV00325_D_CDC | SV00325 | 1 |
SV00325_IU_CDC | SV00325 | 1 | |
| Technician Activity | sv00326_D_CDC | sv00326 | 1 |
sv00326_IU_CDC | sv00326 | 1 | |
| User Define 1 | SV00330_D_CDC | SV00330 | 1 |
SV00330_IU_CDC | SV00330 | 1 | |
| User Define 2 | SV00331_D_CDC | SV00331 | 1 |
SV00331_IU_CDC | SV00331 | 1 | |
| Contract Equipment | SV00403_D_CDC | SV00403 | 1 |
SV00403_IU_CDC | SV00403 | 1 | |
| Equipment Type | SV00405_D_CDC | SV00405 | 1 |
SV00405_IU_CDC | SV00405 | 1 | |
| Manufacturer | SV00410_D_CDC | SV00410 | 1 |
SV00410_IU_CDC | SV00410 | 1 | |
| Model Number | SV00411_D_CDC | SV00411 | 1 |
SV00411_IU_CDC | SV00411 | 1 | |
| Extended Warranty Type | SV00420_D_CDC | SV00420 | 1 |
SV00420_IU_CDC | SV00420 | 1 | |
| Meter Reading | sv00430_D_CDC | SV00430 | 1 |
sv00430_IU_CDC | SV00430 | 1 | |
| Contract | SV00500_D_CDC | SV00500 | 1 |
SV00500_IU_CDC | SV00500 | 1 | |
| Task Code | SV00560_D_CDC | SV00560 | 1 |
SV00560_IU_CDC | SV00560 | 1 | |
| Skill Level | SV00572_D_CDC | SV00572 | 1 |
SV00572_IU_CDC | SV00572 | 1 | |
| Invoice History | SV00701_D_CDC | SV00701 | 1 |
SV00701_IU_CDC | SV00701 | 1 | |
| Service Cost Code | SV00735_IU_CDC | SV00735 | 1 |
| Building | SV01200_D_CDC | SV01200 | 1 |
SV01200_IU_CDC | SV01200 | 1 | |
| Refrigerant Type | SV40180_D_CDC | SV40180 | 1 |
SV40180_IU_CDC | SV40180 | 1 | |
| Refrigerant Code | SV40182_D_CDC | SV40182 | 1 |
SV40182_IU_CDC | SV40182 | 1 | |
| Refrigerant Leak | SV40184_D_CDC | SV40184 | 1 |
SV40184_IU_CDC | SV40184 | 1 | |
| GP Internet Address | SY01200_D_CDC | SY01200 | 1 |
SY01200_IU_CDC | SY01200 | 1 | |
| GP Employee | UPR00100_D_CDC | UPR00100 | 1 |
UPR00100_IU_CDC | UPR00100 | 1 | |
| GP Employee Tax Info | UPR00300_D_CDC | UPR00300 | 1 |
UPR00300_IU_CDC | UPR00300 | 1 | |
| GP Employee Pay Code | UPR00400_D_CDC | UPR00400 | 1 |
UPR00400_IU_CDC | UPR00400 | 1 | |
| GP Employee State Tax | UPR00700_D_CDC | UPR00700 | 1 |
UPR00700_IU_CDC | UPR00700 | 1 | |
| GP Department | UPR40300_D_CDC | UPR40300 | 1 |
UPR40300_IU_CDC | UPR40300 | 1 | |
| GP Position | UPR40301_D_CDC | UPR40301 | 1 |
UPR40301_IU_CDC | UPR40301 | 1 | |
| GP Pay Code | UPR40600_D_CDC | UPR40600 | 1 |
UPR40600_IU_CDC | UPR40600 | 1 | |
| GP Workers Comp | UPR40700_D_CDC | UPR40700 | 1 |
UPR40700_IU_CDC | UPR40700 | 1 | |
| GP Payroll State | UPR41100_D_CDC | UPR41100 | 1 |
UPR41100_IU_CDC | UPR41100 | 1 | |
| Purchase Order Detail | WS10101_D_CDC | WS10101 | 1 |
WS10101_IU_CDC | WS10101 | 1 | |
| TimeTrack Option | WS40000_D_CDC | WS40000 | 1 |
WS40000_IU_CDC | WS40000 | 1 | |
| TimeTrack Registered User | WS41001_D_CDC | WS41001 | 1 |
WS41001_IU_CDC | WS41001 | 1 | |
| Attachment | WSDOCS_D_CDC | WSDOCS | 1 |
WSDOCS_IU_CDC | WSDOCS | 1 |