I am trying to find out how one can enforce settings of the SQL Server Management Studio globally via the registry. We have a small query in place which should in theory do that, however it only does so in the current session and obviously only when the queries are executed.
Furthermore we have faced the problem that, due to internal updates, certain settings are being reset to their standard values, which causes problems with certain other applications we are working with, which is why we are trying to force the settings globally and as easy as possible, meaning registry entries in a best case scenario.
Upon checking the registry I've realized that there is an identical folder structure present to each setting contained in SSMS, however these only contain the standard values for the settings as well as some keys which define what the settings window looks like, and trying out certain values hasn't worked either.
Has anyone had any experience with this and can tell me if what we are trying to achieve is possible and, hopefully, feasible?
The settings I need are:
- Query Execution > SQL Server > Advanced > SET_NOCOUNT = checked
- Query Execution > SQL Server > ANSI > SET ANSI_NULLS = unchecked
- Query Results > SQL Server > General > Default destination for results: = Results to text
(Note that we are using SSMS 18.0 in our Server environments)
What I've tried: As mentioned we have queries in place which should do the expected, but they only do that while in the active session. I have scoured the internet for solutions with registry keys or powershell commands, with no luck. There's also the "Import/Export Settings" function which seemingly does not do anything at all though, unless I have used it wrong.