Microsoft Sql Server, Error 1934

• Emiballs

  SSC Enthusiast

  Points: 189

  More actions

  September 24, 2014 at 2:44 pm

  #290235

  I have a trigger created on my server to capture anytime a SQL login is being created on the server. Everytime I try to create a new login , I get the below error message.The only work around option is to disable the trigger, then I can creted a login. What is a better solution to create a login. I attached the trgger syntax for your review and also the eror message. For your information, I tried running a create syntax with setting the Quoted Identier ON but it still didnt work. Any input is greatly appreciated.

  Create failed for Login 'test'. (Microsoft.SqlServer.Smo)

  Addditional information:

  An exception occured while executing a Transact-SQL statement or batch.

  (Microsoft.SqlServer.ConnectionInfo)

  SELECT failed because the following SET options have incorrrect settings;'QUOTED_IDENTIFIER'.

  verify that SET options are correct for use with indexed views and/or indexes on computed

  columns and/or query notifications an/or xml data type methods. (Microsoft Sql Server, Error 1934)

  -------------------------------------------------------------------------------BEELOW iS THE Trigger Query------------