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. Note that the Entity name does not display in the query results.

Entity	Table Name	Trigger Name
Job	JC00102	JC00102_D_CDC
Job	JC00102	JC00102_IU_CDC
Job Cost Code	JC00701	JC00701_D_CDC
Job Cost Code	JC00701	JC00701_IU_CDC
GP Customer	RM00101	RM00101_D_CDC
GP Customer	RM00101	RM00101_IU_CDC
Technician	SV00115	SV00115_D_CDC
Technician	SV00115	SV00115_IU_CDC
Service Option	sv00196	sv00196_D_CDC
Service Option	sv00196	sv00196_IU_CDC
Location	SV00200	SV00200_D_CDC
Location	SV00200	SV00200_IU_CDC
Service Call	SV00300	SV00300_D_CDC
		SV00300_I_CDC
		SV00300_U_CDC
Appointment	SV00301	SV00301_D_CDC
		SV00301_I_CDC
		SV00301_U_CDC
Equipment	SV00400	SV00400_D_CDC
Equipment	SV00400	SV00400_IU_CDC

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 above query script:

...

Trigger Name

...

Table Name

...

Disabled

...

the disabled triggers script. 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

Entity	Table Name	Trigger Name	Disabled
GP GL Account	GL00100	GL00100_D_CDC

GL00100

1

GL00100_IU_CDC

GL00100

1
Job User Defined	JC00107	JC00107_D_CDC

JC001071

	1
JC00107_IU_CDC

JC00107

1
Estimate Revision	JC00201	JC00201_D_CDC

JC002011

	1
JC00201_IU_CDC

JC00201

1
Forecast Revision	JC00401	JC00401_D_CDC

JC00401

	1
JC00401_IU_CDC	1

JC00401

Job Cost Note

1

JC00501

JC00501_D_CDC

JC00501

	1
JC00501_IU_CDC	1

JC00501

Job Bill Code

1

JC00601

JC00601_D_CDC

JC00601

	1
JC00601_IU_CDC	1

JC00601

Job Revenue Code

1

JC00610

JC00610_D_CDC

JC00610

	1
JC00610_IU_CDC

JC00610

1

	1
Employee Union Code Master	JC00801	JC00801_D_CDC

JC008011

	1
JC00801_IU_CDC

JC00801

1

Change Order

JC01001

JC01001_D_CDC

JC01001

	1
JC01001_IU_CDC

JC01001

1

	1
Change Order Cost Code	JC01002	JC01002_D_CDC

JC010021

	1
JC01002_IU_CDC

JC01002

1
Job Change Order Revenue Code	JC01004	JC01004_D_CDC

JC01004

1
JC01004_IU_CDC	1

JC01004

Job Vendor

1

JC01501

JC01501_D_CDC

JC015011

	1
JC01501_IU_CDC

JC01501

1
Job Vendor Date	JC01504	JC01504_D_CDC

JC015041

	1
JC01504_IU_CDC

JC01504

1
Job Project	JC01701	JC01701_D_CDC

JC017011

	1
JC01701_IU_CDC

JC01701

1
Rate Class	JC01801	JC01801_D_CDC

JC01801

	1
JC01801_IU_CDC	1

JC01801

Job Lien Waiver

1

JC20705

JC20705_D_CDC

JC20705

	1
JC20705_IU_CDC	1

JC20705

Fed Class

1

JC40106

JC40106_D_CDC

JC401061

	1
JC40106_IU_CDC

JC40106

1
Union Code	JC40201	JC40201_D_CDC

JC40201

1

JC40201_IU_CDC

JC40201

1

1
Cost Element	JC40209	JC40209_IU_CDC

JC40209

1
Resource Extension	K2A_ResourceExtension	K2A_ResourceExtension_D_CDC

K2A_ResourceExtension1

	1
K2A_ResourceExtension_IU_CDC

K2A_ResourceExtension

1
GP Purchase Order	POP10100	POP10100_D_CDC

POP10100

1

POP10100_IU_CDC

POP10100

1

	1
GP Purchase Order Detail	POP10110	POP10110_D_CDC

POP10110

	1
POP10110_IU_CDC	1

POP10110

GP Address

1

RM00102

RM00102_D_CDC

RM00102

1
RM00102_IU_CDC	1

RM00102

GP Salesperson

1

RM00301

RM00301_D_CDC

RM00301

1

1
RM00301_IU_CDC	1

RM00301

Installation By

SV_00415

SV_00415_D_CDC

SV_004151

	1
SV_00415_IU_CDC

SV_00415

1
Time Zone	SV00045	SV00045_D_CDC

SV00045

	1
SV00045_IU_CDC

SV00045

1

Division

1

SV00077

SV00077_D_CDC

SV00077

	1
SV00077_IU_CDC	1

SV00077

Note

1

SV000805

SV000805_D_CDC

SV000805

1
SV000805_IU_CDC	1

SV000805

Customer

1

SV00100

SV00100_D_CDC

SV001001

	1
SV00100_IU_CDC

SV00100

1
Technician Vehicle	SV00113	SV00113_D_CDC

SV00113

	1
SV00113_IU_CDC	1

SV00113

Technician Branch

1

SV00114

SV00114_D_CDC

SV00114

1
SV00114_IU_CDC	1

SV00114

Technician Skill Set

1

SV00155

SV00155_D_CDC

SV00155

1
SV00155_IU_CDC	1

SV00155

Sublocation

1

SV00201

SV00201_D_CDC

SV002011

	1
SV00201_IU_CDC

SV00201

1
Problem Type	SV00310	SV00310_D_CDC

SV00310

1

SV00310_IU_CDC

SV00310

1
Call Type	SV00320	SV00320_D_CDC

SV00320

1
SV00320_IU_CDC	1

SV00320

Appointment Status

1

SV00325

SV00325_D_CDC

SV00325

1
SV00325_IU_CDC	1

SV00325

Technician Activity

1

sv00326

sv00326_D_CDC

sv00326

	1
sv00326_IU_CDC

sv00326

1
User Define 1	SV00330	SV00330_D_CDC

SV00330

1

SV00330_IU_CDC

SV00330

1
User Define 2	SV00331	SV00331_D_CDC

SV00331

	1
SV00331_IU_CDC	1

SV00331

Contract Equipment

1

SV00403

SV00403_D_CDC

SV00403

1
SV00403_IU_CDC	1

SV00403

Equipment Type

1

SV00405

SV00405_D_CDC

SV00405

1
SV00405_IU_CDC	1

SV00405

Manufacturer

1

SV00410

SV00410_D_CDC

SV004101

	1
SV00410_IU_CDC

SV00410

1
Model Number	SV00411	SV00411_D_CDC

SV00411

	1
SV00411_IU_CDC	1

SV00411

Extended Warranty Type

1

SV00420

SV00420_D_CDC

SV00420

	1
SV00420_IU_CDC	1

SV00420

Meter Reading

1

SV00430

sv00430_D_CDC

sv00430

1
sv00430_IU_CDC	1

sv00430

Contract

1

SV00500

SV00500_D_CDC

SV005001

	1
SV00500_IU_CDC

SV00500

1
Task Code	SV00560	SV00560_D_CDC

SV005601

	1
SV00560_IU_CDC

SV00560

1
Skill Level	SV00572	SV00572_D_CDC

SV00572

	1
SV00572_IU_CDC	1

SV00572

Invoice History

1

SV00701

SV00701_D_CDC

SV00701

1
SV00701_IU_CDC	1

SV00701

Service Cost Code

1

SV00735

SV00735_IU_CDC

SV00735

1

Building

1

SV01200

SV01200_D_CDC

SV01200

	1
SV01200_IU_CDC	1

SV01200

Refrigerant Type

1

SV40180

SV40180_D_CDC

SV401801

	1
SV40180_IU_CDC

SV40180

1
Refrigerant Code	SV40182	SV40182_D_CDC

SV40182

1

SV40182_IU_CDC

SV40182

1
Refrigerant Leak	SV40184	SV40184_D_CDC

SV40184

1

SV40184_IU_CDC

SV40184

1
GP Internet Address	SY01200	SY01200_D_CDC

SY012001

	1
SY01200_IU_CDC

SY01200

1
GP Employee	UPR00100	UPR00100_D_CDC

UPR00100

1

UPR00100_IU_CDC

UPR00100

1
GP Employee Tax Info	UPR00300	UPR00300_D_CDC

UPR003001

	1
UPR00300_IU_CDC

UPR00300

1
GP Employee Pay Code	UPR00400	UPR00400_D_CDC

UPR004001

	1
UPR00400_IU_CDC

UPR00400

1
GP Employee State Tax	UPR00700	UPR00700_D_CDC

UPR00700

1
UPR00700_IU_CDC	1

UPR00700

GP Department

1

UPR40300

UPR40300_D_CDC

UPR40300

1

UPR40300_IU_CDC

UPR40300

1

GP Position

UPR40301

UPR40301_D_CDC

UPR403011

	1
UPR40301_IU_CDC

UPR40301

1
GP Pay Code	UPR40600	UPR40600_D_CDC

UPR406001

	1
UPR40600_IU_CDC

UPR40600

1
GP Workers Comp	UPR40700	UPR40700_D_CDC

UPR407001

	1
UPR40700_IU_CDC

UPR40700

1
GP Payroll State	UPR41100	UPR41100_D_CDC

UPR411001

	1
UPR41100_IU_CDC

UPR41100

1
Purchase Order Detail	WS10101	WS10101_D_CDC

WS101011

	1
WS10101_IU_CDC

WS10101

1
TimeTrack Option	WS40000	WS40000_D_CDC

WS40000

	1
WS40000_IU_CDC	1

WS40000

TimeTrack Registered User

1

WS41001

WS41001_D_CDC

WS41001

	1
WS41001_IU_CDC	1

WS41001

Attachment

1

WSDOCS

WSDOCS_D_CDC

WSDOCS

1

WSDOCS_IU_CDC

WSDOCS

1

Version	Old Version 2	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