USE [EnVisage]
GO


declare @ClientInfoID uniqueidentifier='063CDC27-D82D-47BA-860B-A01C0530C688'
delete from IntegrationCrmConnectionInfo where ClientInfoId=@ClientInfoID

insert into IntegrationCrmConnectionInfo(ClientInfoId,Id,CrmUrl,CrmUserId,CrmPassword,CrmAccessClass)
values(@ClientInfoID,newid(),'https://icmcusvi2014.crm.dynamics.com/XRMServices/2011/Organization.svc','integrationp@icmcvi.com',
'zAzLDx9NGvJ+t8usMpg24g==','EnVisage.Code.Integration.CRM2016')