SET QUOTTED IDENTIFIER OFF

• Indu Jakhar

  Old Hand

  Points: 337

  More actions

  February 21, 2005 at 5:38 am

  #110103

  Hi!

  I am trying to migrate my database from SQL 7.0 to SQL 2000, I have a great number of stored procedures in that which are using double quotes(") which gives problem in SQL 2000. How can I set QUOTTED IDENTIFIER OFF at server level so that it never give a problem.

  Waiting for responses....

  Indu

  

  ---

  Best Regards,

  Indu Jakhar

• Vint

  Newbie

  Points: 2

  More actions

  February 22, 2005 at 5:13 am

  #543432

  Indu:

  QUOTED_IDENTIFIER is database-level option.

  The model database is the template for all databases created on a system.

  Salute!