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