SET QUOTED_IDENTIFIER setting

[timscronin]

We have several sp's created to support a 3rd pary app that uses crystal inside the app with an odbc connection. We got sql rowse errors on any Citrix server where Use ANSI quoted identifiers was not checked. If we had them checked it works. Does this mean the sp's were created with the identifiers on

 

[mrdenny]

Probably. Check the code of the procedures and see if they are following the quoted identifiers on formating.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com