quote:

---

Originally posted by tkizer

No, you'll need to fix the code. SQL 2000 was more lenient.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

---

set ANSI_NULLS ON 
set QUOTED_IDENTIFIER ON 
go 
 
 
 
ALTER   PROCEDURE [dbo].[OCRCMGetInvalidProductId] 
( 
    @ProductId varchar(4000)='', 
    @StartDt datetime,  
    @EndDt datetime,  
    @StoreId varchar(36),  
    @output varchar(8000) output 
) 
AS 
 
IF(LEN(@ProductId) > 0) 
    SELECT @output = coalesce(@output + ',' , '') + col 
    FROM 
    ( 
        SELECT DISTINCT col  
         FROM 
         fn_OC_ProduceListFromString(@ProductId) 
         WHERE col NOT IN 
         ( 
            SELECT DISTINCT p.ProductID 
            FROM tblProductAuthorization pa JOIN tblProduct p ON ppa.ProductID = p.ProductId      
            JOIN fn_OC_ProduceListFromString(@ProductId) pl ON p.ProductID=pl.col 
            WHERE pa.StoreId =@StoreId and p.ActiveFlg=1 
            AND  
            (  
                (@StartDt >= pa.EffectiveDt AND @StartDt <= pa.ExpirationDt) 
                OR 
                (@EndDt >= pa.EffectiveDt AND @EndDt <= pa.ExpirationDt) 
            ) 
         ) 
    ) t1 
ELSE 
    SELECT @output = ''; 

quote:

---

Originally posted by darkdusky

Can you run:
sp_dboption 'DBNAME'
against both databases to see if settings are different - esp quoted identifier

---