Options
setup script fails
GraemeH
Posts: 3
Hi,
I have run the setup script on one of my servers and it was fine however on the second server we get the following messages and the script does not complete?
Msg 1934, Level 16, State 1, Procedure Audit_All_DB_Events, Line 15
INSERT failed because the following SET options have incorrect settings: 'ANSI_NULLS, QUOTED_IDENTIFIER'. 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.
Msg 1934, Level 16, State 1, Procedure Audit_All_DB_Events, Line 15
INSERT failed because the following SET options have incorrect settings: 'ANSI_NULLS, QUOTED_IDENTIFIER'. 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.
Msg 1934, Level 16, State 1, Procedure Audit_All_DB_Events, Line 15
INSERT failed because the following SET options have incorrect settings: 'ANSI_NULLS, QUOTED_IDENTIFIER'. 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.
The module 'RG_SQLLighthouse_DDLTrigger' depends on the missing object 'master.dbo.RG_SQLLighthouse_WriteEvent'. The module will still be created; however, it cannot run successfully until the object exists.
The module 'RG_SQLLighthouse_DDLTrigger' depends on the missing object 'master.dbo.RG_SQLLighthouse_WriteError'. The module will still be created; however, it cannot run successfully until the object exists.
Msg 1934, Level 16, State 1, Procedure Audit_All_DB_Events, Line 15
INSERT failed because the following SET options have incorrect settings: 'ANSI_NULLS, QUOTED_IDENTIFIER'. 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.
Msg 3902, Level 16, State 1, Line 14
The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.
Everything looks the same when I have checked the servers connection properties, can anyone help?
Thanks
I have run the setup script on one of my servers and it was fine however on the second server we get the following messages and the script does not complete?
Msg 1934, Level 16, State 1, Procedure Audit_All_DB_Events, Line 15
INSERT failed because the following SET options have incorrect settings: 'ANSI_NULLS, QUOTED_IDENTIFIER'. 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.
Msg 1934, Level 16, State 1, Procedure Audit_All_DB_Events, Line 15
INSERT failed because the following SET options have incorrect settings: 'ANSI_NULLS, QUOTED_IDENTIFIER'. 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.
Msg 1934, Level 16, State 1, Procedure Audit_All_DB_Events, Line 15
INSERT failed because the following SET options have incorrect settings: 'ANSI_NULLS, QUOTED_IDENTIFIER'. 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.
The module 'RG_SQLLighthouse_DDLTrigger' depends on the missing object 'master.dbo.RG_SQLLighthouse_WriteEvent'. The module will still be created; however, it cannot run successfully until the object exists.
The module 'RG_SQLLighthouse_DDLTrigger' depends on the missing object 'master.dbo.RG_SQLLighthouse_WriteError'. The module will still be created; however, it cannot run successfully until the object exists.
Msg 1934, Level 16, State 1, Procedure Audit_All_DB_Events, Line 15
INSERT failed because the following SET options have incorrect settings: 'ANSI_NULLS, QUOTED_IDENTIFIER'. 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.
Msg 3902, Level 16, State 1, Line 14
The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.
Everything looks the same when I have checked the servers connection properties, can anyone help?
Thanks
Comments
Problem solved QUOTED_IDENTIFIER and ANSI_NULLS had inadvertently been set to OFF in a home-grown trigger in master.
Thanks
Graeme