Getting following error message while run below "create login" script on one particular SQL server 2008 server. But same script i can execute all other SQL server 2008 R2 except one server. I guess some settings are missing that particular server please help me to sort out this issue.
I tried to enable quoted identifier and others but it is nor working.
Msg 1934, Level 16, State 1, Procedure RemovePolicy, Line 29
SELECT failed because the following SET options have incorrect settings: '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.
CREATE LOGIN [Test1] WITH PASSWORD=0x01009617281BC2C1905B49410AC0C255FE0E430AA46DD900E8C1C226CBC910946BFCCFA170B66CC7E03813B1BE86 HASHED, CHECK_POLICY=OFF, SID=0xB1F70696AF3FA54B961EC1D7E4049306