Sybase Central has a nice screen showing the comparison of your current database options against the defaults (accessed by right-clicking on the database name and choosing Options).
I'm trying to run a query that identifies non-standard settings on customers databases (we recently had a problem with a setting that had crept in unnoticed). I'd hope to find that one of the system stored procedures or system views had the default values in there that I could use in a comparison, but can't find anything.
Does Sybase Central "just know" the default values? I tried setting request level logging when using the feature but it didn't ask the database!
asked 15 Mar, 09:49