Results 1 to 5 of 5

Thread: Trigger

  1. #1
    Join Date
    Aug 2003
    Posts
    328

    Unanswered: Trigger

    In a trigger, is there any possible way the SET QUOTED_IDENTIFIER would be set to off at the start? I made 4 triggers, and I noticed that one of them starts with setting the quoted identifier to off. It seems odd that this would be set like this.
    Thanks

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    SET QUOTED_IDENTIFIER has no effect inside your trigger or stored procedure. This setting (along with ANSI_NULLS) needs to be in effect when you create your triggers.

  3. #3
    Join Date
    Aug 2003
    Posts
    328
    I made 4 triggers on several tables in the SQL Server. These tables are a backend to a property title front end application. 3 of the triggers start with setting the quoted identifier to on while one of them starts with setting the quoted identifier to off. I thought the default was on. I didn't set it to off. Can the SQL Server set it to off somehow?
    Thanks.

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    If you use EM when creating Transact-SQL-based objects (stored procedures, triggers, functions, views), then the default is OFF. But when you do in QA, then the settings can be modified in Connection Options for the current open window, or in Tools/Options/Connection Properties for all consequent connections.

  5. #5
    Join Date
    Aug 2003
    Posts
    328
    I got you. Thanks very much.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •