Hi all,
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.
Error :
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.
Script :
CREATE LOGIN [Test1] WITH PASSWORD=0x01009617281BC2C1905B49410AC0C255FE0E430AA46DD900E8C1C226CBC910946BFCCFA170B66CC7E03813B1BE86 HASHED, CHECK_POLICY=OFF, SID=0xB1F70696AF3FA54B961EC1D7E4049306
Thanks -
Rajeev R