[SA 9.0.166 Pro] Use same target for multiple DB types?

Changes are indeed appear as sticky in the options, but they are more or less cosmetic., they don't alter the behavior of SQL Editor which is specifically designed to recognize database type based on connection details and automatically pick matching SQL Assistance type and the connection specific attributes. If you know how to break that, I mean how to change connection to a different database type and the SQL Editor not following with correct SQL Assistance type and not showing any warnings, please describe the steps. This is an issue that we would like to fix.

I guess the assistance is properly set when changing connection types. The auto connection is another question. And we might be afraid about the SQL reference as well. Though I admit, I've never tried to intentionally break those, so it's all theory.

One way to mismatch things is to use Ctrl+Shift+F5 while already connected to a database like Oracle, and choose SQL Server Assistance type. That is allowed on purpose, by design. It's there in case things require manual corrections. Another way is to choose a DSN-based ODBC connection to a wrong database. Or select ADO.NET interface with with a wrong server and port. If SQL Assistant detects mismatch between server type and assistance type selected, it shows a warning. But that warning can still be ignored.