When you create a company in your CRM database and at the same time looking to create the same company in another CRM database, then you can do this by defining below trigger for your source database:<\/p>\n
CREATE TRIGGER trig_insert_Company
ON [CRMSOURCEDB].[dbo].[Company]
FOR INSERT
AS<\/p>\n
DECLARE @Company_Id AS INT
EXEC @Company_Id = [CRMDESTDB].dbo.eware_get_identity_id ‘Company’<\/p>\n
INSERT [CRMDESTDB].dbo.Company (comp_companyid,comp_name,comp_type)
SELECT @Company_Id,comp_name,comp_type
FROM inserted<\/p>\n","protected":false},"excerpt":{"rendered":"
When you create a company in your CRM database and at the same time looking to create the same company in another CRM database, then you can do this by defining below trigger for your source database: CREATE TRIGGER trig_insert_CompanyON [CRMSOURCEDB].[dbo].[Company]FOR INSERTAS DECLARE @Company_Id AS INTEXEC @Company_Id = [CRMDESTDB].dbo.eware_get_identity_id ‘Company’ INSERT [CRMDESTDB].dbo.Company (comp_companyid,comp_name,comp_type)SELECT @Company_Id,comp_name,comp_typeFROM inserted<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[765,766],"class_list":["post-95","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-copy","tag-copy-company"],"yoast_head":"\n