question

caoneill avatar image
caoneill asked

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.
user
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
caoneill avatar image
caoneill answered
Never mind. I saw that a server level trigger was added yesterday through a script and I removed it. I can add logins now. Thanks! DROP TRIGGER [DDL_NU_MODIFY_LOGIN] ON ALL SERVER
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.