Can no longer create logins on a server - Select failed because of the following SET options
SQL 2012 Just trying to create a new login on a server and got the below error. Created multiple users previously. Any ideas? Thank you! USE [master] GO CREATE LOGIN [Test_acct] WITH PASSWORD=N'123', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO Error: Msg 1934, Level 16, State 1, Procedure DDL_NU_MODIFY_LOGIN, Line 10 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.