Database Options

• Ramesh Lende

  Ten Centuries

  Points: 1034

  More actions

  August 21, 2008 at 12:44 pm

  #197226

  Hello:

  I have an application which works fine in one database but gives following eror in other database. I want to check how to find out what are current Database Options for both the server to make sure it is fine.

  How can i check current database options for both the datbases? I tried running sp_dboptions but it does not help.

  Error i am getting is

  ERROR OCCURRED: 50000 , ERROR OCCURRED: 1934 , SELECT failed because the following SET options have incorrect settings: 'ANSI_NULLS, 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

  Thanks,

  Ramesh.

• jeffrey yao

  SSCarpal Tunnel

  Points: 4364

  More actions

  August 21, 2008 at 1:07 pm

  #861501

  try DBCC useroptions in both environments and compare the results.

  HTH

  JY