is there a way to need to find out what the
ANSI_PADDING etc. settings where when a given procedure was created in my database ?
It seems my customer there has several stored procedures and a few triggers that have been "tweaked" - but unfortunately, using a "wrong" set of those database settings. Can I find out which procs and triggers are affected, or do I need to re-create all of them with the proper settings?