To enable or disable

Table of Contents

maxLevel	1

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:

SELECT sysobjects.name AS trigger_name, OBJECT_NAME(parent_obj) AS table_name,

OBJECTPROPERTY(id, 'ExecIsTriggerDisabled') AS [disabled]

FROM sysobjects

WHERE sysobjects.type = 'TR' AND sysobjects.name LIKE '%_CDC'

and OBJECTPROPERTY(id, 'ExecIsTriggerDisabled') = 0

ORDER BY disabled,sysobjects.name ASC

Enabled Triggers Query Results

These are the results of the enabled triggers script query, assuming all nine triggers are enabled:

...

Trigger Name

...

. Note that the Entity name does not display in the query results.

0000000

Entity	Table Name	Trigger Name	Disabled
Job	JC00102	JC00102_D_CDCJC00102	0
Job	JC00102	JC00102_IU_CDC	0 JC00102
Job Cost Code	JC00701	JC00701_D_CDCJC00701	0
Job Cost Code	JC00701	JC00701_IU_CDC	0 JC00701
GP Customer	RM00101	RM00101_D_CDCRM00101	0
GP Customer	RM00101	RM00101_IU_CDC	0 RM00101
Technician	SV00115	SV00115_D_CDCSV00115	0
Technician	SV00115	SV00115_IU_CDC	0 SV00115
Service Option	sv00196	sv00196_D_CDCsv00196	0
Service Option	sv00196	sv00196_IU_CDC	0 sv00196
Location	SV00200	SV00200_D_CDC	SV00200	0
Location	SV00200	SV00200_IU_CDC	SV00200	0 0
Service Call	SV00300	SV00300_D_CDCSV00300	0
		SV00300_I_CDCSV00300	0
		SV00300_U_CDC	0 SV00300
Appointment	SV00301	SV00301_D_CDCSV00301	0
		SV00301_I_CDCSV00301	0
		SV00301_U_CDC	0 SV00301
Equipment	SV00400	SV00400_D_CDCSV00400	0
Equipment	SV00400	SV00400_IU_CDCSV00400	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:

SELECT sysobjects.name AS trigger_name, OBJECT_NAME(parent_obj) AS table_name,

OBJECTPROPERTY(id, 'ExecIsTriggerDisabled') AS [disabled]

FROM sysobjects

WHERE sysobjects.type = 'TR' AND (sysobjects.name LIKE '%_D_CDC' or sysobjects.name LIKE '%_IU_CDC')

and OBJECTPROPERTY(id, 'ExecIsTriggerDisabled') = 1

ORDER BY disabled,sysobjects.name ASC

Disabled Triggers Query Results

GP Database Level

These are the query results at the GP database level from the disabled triggers script, assuming the default nine triggers have been enabled:

...

Trigger Name

...

Table Name

...

Disabled

. Note that the Entity name does not display in the query results.

Entity	Table Name	Trigger Name	Disabled
Call Source	SVCALSRC	SVCALLSRC_D_CDC	1
Call Source	SVCALSRC	SVCALLSRC_IU_CDC	1
GP Company	SY01500	SY01500_D_CDC	1
GP Company	SY01500	SY01500_IU_CDC	1

Company Database Level

GL001001JC001071JC002011JC004011JC005011JC006011JC008011JC010041JC0150111JC017011JC018011JC207051JC401061JC4020111POP101101RM001021111SV000771SV0008051SV001001SV001131SV001141SV001551SV002011SV003101SV003201SV003251SV003301SV0033111SV004051SV004101SV004111SV004201sv004301SV005001SV0056011SV007011SV007351SV012001SV401801SV401821SV401841SY012001UPR007001UPR403001UPR403011UPR406001UPR407001UPR411001WS101011WS400001WS410011

Entity	Table Name	Trigger Name	Disabled
GP GL Account	GL00100	GL00100_D_CDC	GL00100	1
GP GL Account	GL00100	GL00100_IU_CDC	1
Job User Defined	JC00107	JC00107_D_CDCJC00107	1
Job User Defined	JC00107	JC00107_IU_CDC	1
Estimate Revision	JC00201	JC00201_D_CDCJC00201	1
Estimate Revision	JC00201	JC00201_IU_CDC	1
Forecast Revision	JC00401	JC00401_D_CDCJC00401	1
Forecast Revision	JC00401	JC00401_IU_CDC	1
Job Cost Note	JC00501	JC00501_D_CDCJC00501	1
Job Cost Note	JC00501	JC00501_IU_CDC	1
Job Bill Code	JC00601	JC00601_D_CDCJC00601	1
Job Bill Code	JC00601	JC00601_IU_CDC	1
Job Revenue Code	JC00610	JC00610_D_CDCJC00610	1
Job Revenue Code	JC00610	JC00610_IU_CDC	JC00610	1	1
Employee Union Code Master	JC00801	JC00801_D_CDCJC00801	1
Employee Union Code Master	JC00801	JC00801_IU_CDC	1
Change Order	JC01001	JC01001_D_CDCJC01001	1
Change Order	JC01001	JC01001_IU_CDC	JC01001	1	1
Change Order Cost Code	JC01002	JC01002_D_CDCJC01002	1
Change Order Cost Code	JC01002	JC01002_IU_CDC	JC01002	1	1
Job Change Order Revenue Code	JC01004	JC01004_D_CDCJC01004	1
Job Change Order Revenue Code	JC01004	JC01004_IU_CDC	1
Job Vendor	JC01501	JC01501_D_CDCJC01501	1
Job Vendor	JC01501	JC01501_IU_CDC	1
Job Vendor Date	JC01504	JC01504_D_CDCJC01504	1
Job Vendor Date	JC01504	JC01504_IU_CDC	JC01504	1
Job Project	JC01701	JC01701_D_CDC	JC01701	1
Job Project	JC01701	JC01701_IU_CDC	1
Rate Class	JC01801	JC01801_D_CDCJC01801	1
Rate Class	JC01801	JC01801_IU_CDC	1
Job Lien Waiver	JC20705	JC20705_D_CDCJC20705	1
Job Lien Waiver	JC20705	JC20705_IU_CDC	1
Fed Class	JC40106	JC40106_D_CDCJC40106	1
Fed Class	JC40106	JC40106_IU_CDC	1
Union Code	JC40201	JC40201_D_CDCJC40201	1
Union Code	JC40201	JC40201_IU_CDC	1
Cost Element	JC40209	JC40209_IU_CDC	1	JC40209
Resource Extension	K2A_ResourceExtension	K2A_ResourceExtension_D_CDCK2A_ResourceExtension	1
Resource Extension	K2A_ResourceExtension	K2A_ResourceExtension_IU_CDC	K2A_ResourceExtension	1	1
GP Purchase Order	POP10100	POP10100_D_CDCPOP10100	1
GP Purchase Order	POP10100	POP10100_IU_CDC	POP10100	1	1
GP Purchase Order Detail	POP10110	POP10110_D_CDCPOP10110	1
GP Purchase Order Detail	POP10110	POP10110_IU_CDC	1
GP Address	RM00102	RM00102_D_CDCRM00102	1
GP Address	RM00102	RM00102_IU_CDC	1
GP Salesperson	RM00301	RM00301_D_CDCRM00301	1
GP Salesperson	RM00301	RM00301_IU_CDC	1	RM00301
Installation By	SV_00415	SV_00415_D_CDCSV_00415	1
Installation By	SV_00415	SV_00415_IU_CDC	SV_00415	1
Time Zone	SV00045	SV00045_D_CDCSV00045	1
Time Zone	SV00045	SV00045_IU_CDCSV00045	1
Division	SV00077	SV00077_D_CDCSV00077	1
Division	SV00077	SV00077_IU_CDC	1
Note	SV000805	SV000805_D_CDCSV000805	1
Note	SV000805	SV000805_IU_CDC	1
Customer	SV00100	SV00100_D_CDCSV00100	1
Customer	SV00100	SV00100_IU_CDC	1
Technician Vehicle	SV00113	SV00113_D_CDCSV00113	1
Technician Vehicle	SV00113	SV00113_IU_CDC	1
Technician Branch	SV00114	SV00114_D_CDCSV00114	1
Technician Branch	SV00114	SV00114_IU_CDC	1
Technician Skill Set	SV00155	SV00155_D_CDCSV00155	1
Technician Skill Set	SV00155	SV00155_IU_CDC	1
Sublocation	SV00201	SV00201_D_CDCSV00201	1
Sublocation	SV00201	SV00201_IU_CDC	1
Problem Type	SV00310	SV00310_D_CDC	SV00310	1
Problem Type	SV00310	SV00310_IU_CDC	1
Call Type	SV00320	SV00320_D_CDCSV00320	1
Call Type	SV00320	SV00320_IU_CDC	1
Appointment Status	SV00325	SV00325_D_CDCSV00325	1
Appointment Status	SV00325	SV00325_IU_CDC	1
Technician Activity	sv00326	sv00326_D_CDCsv00326	1
Technician Activity	sv00326	sv00326_IU_CDCsv00326	1
User Define 1	SV00330	SV00330_D_CDCSV00330	1
User Define 1	SV00330	SV00330_IU_CDC	1
User Define 2	SV00331	SV00331_D_CDCSV00331	1
User Define 2	SV00331	SV00331_IU_CDC	1
Contract Equipment	SV00403	SV00403_D_CDCSV00403	1
Contract Equipment	SV00403	SV00403_IU_CDC	SV00403	1
Equipment Type	SV00405	SV00405_D_CDCSV00405	1
Equipment Type	SV00405	SV00405_IU_CDC	1
Manufacturer	SV00410	SV00410_D_CDCSV00410	1
Manufacturer	SV00410	SV00410_IU_CDC	1
Model Number	SV00411	SV00411_D_CDCSV00411	1
Model Number	SV00411	SV00411_IU_CDC	1
Extended Warranty Type	SV00420	SV00420_D_CDCSV00420	1
Extended Warranty Type	SV00420	SV00420_IU_CDC	1
Meter Reading	SV00430	sv00430_D_CDCsv00430	1
Meter Reading	SV00430	sv00430_IU_CDC	1
Contract	SV00500	SV00500_D_CDCSV00500	1
Contract	SV00500	SV00500_IU_CDC	1
Task Code	SV00560	SV00560_D_CDCSV00560	1
Task Code	SV00560	SV00560_IU_CDC	1
Skill Level	SV00572	SV00572_D_CDCSV00572	1
Skill Level	SV00572	SV00572_IU_CDC	SV00572	1
Invoice History	SV00701	SV00701_D_CDCSV00701	1
Invoice History	SV00701	SV00701_IU_CDC	1
Service Cost Code	SV00735	SV00735_IU_CDC	1
Building	SV01200	SV01200_D_CDCSV01200	1
Building	SV01200	SV01200_IU_CDC	1
Refrigerant Type	SV40180	SV40180_D_CDC	SV40180	1
Refrigerant Type	SV40180	SV40180_IU_CDC	1
Refrigerant Code	SV40182	SV40182_D_CDCSV40182	1
Refrigerant Code	SV40182	SV40182_IU_CDC	1
Refrigerant Leak	SV40184	SV40184_D_CDCSV40184	1
Refrigerant Leak	SV40184	SV40184_IU_CDC	1
GP Internet Address	SY01200	SY01200_D_CDC	SY01200	1
GP Internet Address	SY01200	SY01200_IU_CDC	1
GP Employee	UPR00100	UPR00100_D_CDCUPR00100	1
GP Employee	UPR00100	UPR00100_IU_CDC	UPR00100	1	1
GP Employee Tax Info	UPR00300	UPR00300_D_CDCUPR00300	1
GP Employee Tax Info	UPR00300	UPR00300_IU_CDC	UPR00300	1	1
GP Employee Pay Code	UPR00400	UPR00400_D_CDCUPR00400	1
GP Employee Pay Code	UPR00400	UPR00400_IU_CDC	UPR00400	1	1
GP Employee State Tax	UPR00700	UPR00700_D_CDCUPR00700	1
GP Employee State Tax	UPR00700	UPR00700_IU_CDC	1
GP Department	UPR40300	UPR40300_D_CDCUPR40300	1
GP Department	UPR40300	UPR40300_IU_CDC	1
GP Position	UPR40301	UPR40301_D_CDCUPR40301	1
GP Position	UPR40301	UPR40301_IU_CDC	1
GP Pay Code	UPR40600	UPR40600_D_CDCUPR40600	1
GP Pay Code	UPR40600	UPR40600_IU_CDC	1
GP Workers Comp	UPR40700	UPR40700_D_CDCUPR40700	1
GP Workers Comp	UPR40700	UPR40700_IU_CDC	1
GP Payroll State	UPR41100	UPR41100_D_CDCUPR41100	1
GP Payroll State	UPR41100	UPR41100_IU_CDC	1
Purchase Order Detail	WS10101	WS10101_D_CDC	WS10101	1
Purchase Order Detail	WS10101	WS10101_IU_CDC	1
TimeTrack Option	WS40000	WS40000_D_CDCWS40000	1
TimeTrack Option	WS40000	WS40000_IU_CDC	1
TimeTrack Registered User	WS41001	WS41001_D_CDCWS41001	1
TimeTrack Registered User	WS41001	WS41001_IU_CDC	1
Attachment	WSDOCS	WSDOCS_D_CDC	WSDOCS	1
Attachment	WSDOCS	WSDOCS_IU_CDCWSDOCS	1

Version	Old Version 5	New Version Current
Changes made by	Documentation Reviewer	Documentation Reviewer
Saved on	Apr 13, 2021	Apr 15, 2021

Versions Compared

Key

Enabling a Trigger in Microsoft SQL Server Management Studio

Enabled Triggers Script

Enabled Triggers Query Results

Disabled Triggers Script

Disabled Triggers Query Results

GP Database Level

Company Database Level

Page Comparison

Versions Compared

Key

Enabling a Trigger in Microsoft SQL Server Management Studio

Enabled Triggers Script

Enabled Triggers Query Results

Disabled Triggers Script

Disabled Triggers Query Results

GP Database Level

Company Database Level