>Hi All,
>
>The following query returns below listed error message:
>

Can you try in SP

;with cte (select distinct EDP from  [AMSWHSERVER3\AMS].slotting.dbo.productinfo)

select CASE WHEN LTRIm(RTRIM(LEN(cUPCNo))) = 5 THEN '0'+ LTRIM(RTRIm(cUPCNo)) ELSE LTRIM(RTRIm(cUPCNo)) END as cUPCNo, 
>		cSKUId, iForecastQty, cEDPNo, cMacsDescript, 
>		cECometryVendorNo, cPVB, cProductTypeId, iWarehouseLocId, 
>		cProductFamilyId, nCaseQty,
>		CASE WHEN lBuyInCase = 1 THEN 'YES' ELSE 'NO' END as lBuyInCase
>	from [BIZTALK\PRODUCTION1].MerchNew.dbo.m_newItem N 
                     LEFT JOIN CTE ON N.cEDPNo = cte.cEDPNo
>	where lSlottingUpload = 1 and CTE.cEDPNo IS NULL
>	And dSlottingUpload = '2009-06-17 13:35:15.000'

Adjust the aliases accordingly


>

>select CASE WHEN LTRIm(RTRIM(LEN(cUPCNo))) = 5 THEN '0'+ LTRIM(RTRIm(cUPCNo)) ELSE LTRIM(RTRIm(cUPCNo)) END as cUPCNo, 
>		cSKUId, iForecastQty, cEDPNo, cMacsDescript, 
>		cECometryVendorNo, cPVB, cProductTypeId, iWarehouseLocId, 
>		cProductFamilyId, nCaseQty,
>		CASE WHEN lBuyInCase = 1 THEN 'YES' ELSE 'NO' END as lBuyInCase
>	from [BIZTALK\PRODUCTION1].MerchNew.dbo.m_newItem
>	where lSlottingUpload = 1
>	And dSlottingUpload = '2009-06-17 13:35:15.000'
>	And cEDPNo not in (select distinct EDP from  [AMSWHSERVER3\AMS].slotting.dbo.productinfo)
>
>
>OLE DB provider "SQLNCLI" for linked server "AMSWHSERVER3\AMS" returned message "Cannot create new connection because in manual or distributed transaction mode.".
>Msg 7320, Level 16, State 2, Line 1
>Cannot execute the query "SELECT TOP 1 1 FROM "slotting"."dbo"."productinfo" "Tbl1005"" against OLE DB provider "SQLNCLI" for linked server "AMSWHSERVER3\AMS". 
>
>

>
>
>BIZTALK\PRODUCTION1 = SQL Server 2005
>AMSWHSERVER3\AMS = SQL Server 2000
>
>Any idea why?
>
>TIA,
>Daniel