| Table of Contents | ||
|---|---|---|
|
Enabling a Trigger in Microsoft SQL Server Management Studio
...
| 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:
...
| 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 |