Create Same Company in another Database

By | March 16, 2009

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_Company
ON [CRMSOURCEDB].[dbo].[Company]
FOR INSERT
AS

DECLARE @Company_Id AS INT
EXEC @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_type
FROM inserted