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
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.
