error while disabling publishere distributer on a server.

• subhendu.tiwari

  SSC Rookie

  Points: 45

  More actions

  January 21, 2010 at 12:46 am

  #229269

  Disabling Publishing...

  - Verifying the Distributor is available (Success)

  - Disabling publishing (Error)

  Messages

  * SQL Server could not disable publishing on 'NIIT-52AF86EED8'. (Microsoft.SqlServer.ConnectionInfo)

  ------------------------------

  ADDITIONAL INFORMATION:

  An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

  ------------------------------

  INSERT 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 query notifications and/or xml data type methods.

  Changed database context to 'master'. (Microsoft SQL Server, Error: 1934)

  For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.4053&EvtSrc=MSSQLServer&EvtID=1934&LinkId=20476

• noeld

  SSC Guru

  Points: 96590

  More actions

  January 21, 2010 at 8:56 am

  #1106763

  Check your connection settings in SSMS .... make sure you have the required connection settings as specified by the Error

  
  * Noel