November 21, 2004 at 9:50 pm
I am getting the following error when attempting to run a stored proc:
INSERT failed because the following SET options have incorrect settings: 'ANSI_NULLS.', 'QUOTED_IDENTIFIER'
The stored proc attempts to insert records from one SQL table into another.
I have researched the issue somewhat. I would like some guidance on exactly how to change the Set options.
Thanks,
Bill
November 22, 2004 at 9:50 am
HOW to change them:
Just run the following commands before you re-create/alter the stored Proc:
SET QUOTED_IDENTIFIER OFF -- (or ON)
GO
SET ANSI_NULLS ON -- (or OFF)
GO
November 22, 2004 at 10:45 am
DavidT,
Thanks for the reply.
Could I insert:
SET QUOTED_IDENTIFIER OFF -- (or ON)
GO
SET ANSI_NULLS ON -- (or OFF)
GO
In the stored proc ahead of the Create statement?
Bill
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply