3 Replies Latest reply on Sep 20, 2019 12:38 AM by Amit Kumar

    Unable to create new fields or forms on production Remedy server

    Timothy Hulmes
      Share This:

      Any attempt to create new fields (on a Regular form) results in a SQL error as follows:
      INSERT failed because the following SET options have incorrect settings: 'CONCAT_NULL_YIELDS_NULL'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations.
      Remedy version 9.1.04
      SQL Version 2014
      Any thoughts or suggestions?