Msg 1934, Level 16, State 1, Procedure RemovePolicy, Line 29

11 views
Skip to first unread message

Rajeev R

unread,
Sep 10, 2013, 1:29:03 PM9/10/13
to chns...@googlegroups.com
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
Reply all
Reply to author
Forward
0 new messages