SQL server configuration manager is used to configure certain settings like connection protocols, service start up, etc... Is it possible to make these changes that is done in SQL server configuration manager by using TSQL statements, or in the SSMS?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
Most settings that can't be done via sp_configure are registry based
So, you can use
One examples , protocols is under
and each of these has an
One important note: you can stop SQL Server from xp_cmdshell or using SHUTDOWN but not start it of course...
Going to have to go with the good ol' "it depends on what you want to do"
You could use the xp_cmdshell or powershell to change or start some options. For example if you want to start your SQL agent do this:
If you want to change server protocols with powershell, check out - http://msdn.microsoft.com/en-us/library/dd206997.aspx
Powershell is like it says, powerful.