Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database Options Expand / Collapse
Author
Message
Posted Thursday, August 21, 2008 12:44 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, June 3, 2011 9:11 AM
Points: 64, Visits: 104
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.
Post #556842
Posted Thursday, August 21, 2008 1:07 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 1:34 PM
Points: 228, Visits: 703
try DBCC useroptions in both environments and compare the results.

HTH

JY



Post #556855
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse