SQL Server Performance

script fails while running as job

Discussion in 'General DBA Questions' started by raagi2000, Mar 15, 2006.

  1. raagi2000 New Member

    Hello guyz , i can able to run the script without a problem in query analyzer but when i schedule it fails with error Executed as user: GLOBALusdbadmin. INSERT failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. [SQLSTATE 42000] (Error 1934). The step failed. by default its turned ON. there is nothing quoted (")in the script to represent column or table or any object. its all direct select statements without quotes. user GLOBALusdbadmin is sysadmin

    USE dbname
    go
    SET IMPLICIT_TRANSACTIONS ON
    go

    -- code to DROP indexes
    -- code to CREATE index

    COMMIT
    go
  2. satya Moderator

    Try
    set arithabort on
    GO
    SET QUOTED_IDENTIFIER on
    GO
    SET ANSI_NULLS ON
    GO

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page