April 3, 2017 at 4:35 am
Hello,
We have restored a db from SQL 2008 to SQL 2016. on execution of an stp we are facing following error "Insert failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. Below is the exec statement
declare @p xml
Set @p = convert(xml,N'<root><row><sEmployId>ABC</sEmployId><sDeptId>1</sDeptId>
exec stp_ABC @FileName=N'A5',@xmlPortfolio=@p
Surprisingly we found out that problem is not with the different versions i.e. (2008 to 2016) because on another restored db of different backup, the above query works fine.
Please guide for the same
April 3, 2017 at 4:46 am
The database that works, is it on the same server as the one that doesn't? Are you running both under the same login? Please will you script the stored procedure and post the whole output?
John
April 3, 2017 at 5:52 am
The databases are on the same server and same login. In fact i checked the both database quoted_identifier properties and its false. Then i set to true in which the error comes and again executed the script but it still shows error.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply