I have to check programmatically if the SQL Server service needs restarting after series of changes in configuration.
Is there any indicator (e.g. in the system registry) that allows to obtain this information?
sql server
I have to check programmatically if the SQL Server service needs restarting after series of changes in configuration.
Is there any indicator (e.g. in the system registry) that allows to obtain this information?
Best Answer
You can check for differences between value_in_use and value in sys.configurations for non dynamic changes.
to check for a changed logginmode