One of our programs is erroring out because a stored procedure was "created with QUOTED_IDENTIFIER option ON". This is a Microsoft SQL Server (8). All that happened to it yesterday was: Stored procedures were editted. A table was created. I have removed the edits. I have deleted the table. The error is still coming up. Is there a que...
I'm trying to create an SSIS 2008 Data Source View that reads from an Ingres database via the ODBC driver for Ingres. I've downloaded the Ingres 10 Community Edition to get the ODBC driver, installed it, set up the data access server and a DSN on the server running SSIS. If I connect to the SQL Server 2008 Database Engine on the server ...
Can anyone provide insight into this? I've developed an import process using an XML data type. After the data is inserted in to a table by the import sProc I run another procedures to update another table with the imported table. The update procedure throws an exception if it is created with SET QUOTED_IDENTIFIER OFF. I'd like to under...