We've found that some stored procedures were created with different ANSI_NULLS settings between our development and test databases. My thought is that maybe the ANSI_NULLS setting is stored within the STATUS column in SYSOBJECTS. Can anyone confirm this? It looks like STATUS is a set of bytes used for multiple settings. Anyone know which bytes go with which settings?

I checked in the MS help (don't ask me why) and it just says that the field is for internal use. Wouldn't want to actually give us any useful information, we might hurt ourselves....

Thanks for any info!

-Tom.