I can change SQL Server settings using Management Studio or programmatically as described e.g. here.
I would like to make this changes WITHOUT the need to restart SQL Server services. Is there any trick to do so??
migrated from stackoverflow.com May 13 '13 at 13:55
This question came from our site for professional and enthusiast programmers.
If you want to change the Authentication Mode, you can do this by running the following SQL
You may also have to ensure that the
You will however still have to restart the SQL Server service.
It depends on what settings you changed based on http://msdn.microsoft.com/en-GB/library/ms189631.aspx. Some require a restart (RR), other can be done via RECONFIGURE
There is no trick or workaround. At all.
Edit, now we know it is Authentication mode...
This is automatically deals with the instance name
Restart is still needed