When you've created the stored procedure the settings for ANSI_NULLS and
QUOTED_ITEDENTIFIER would have been off. They should be on at the time of
stored procedure creation.
Script the existing stored procedure.
drop the the stored procedure.
SET the following options in Query yzer before running the scripted
"Create procedure" statement.
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
--Create the stored procedure again.
"Patrick" <all-in-1.com> wrote in message