InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 14:59:43 GMT20http://www.sqlservercentral.com/Forums/Topic1401431-392-1.aspx[quote][b]pooya1072 (1/1/2013)[/b][hr]can i use this to restart SQL service ...like that i Right click on Server name and Choose Restart.i want do this in T-SQL.[/quote]No, unfortunately not. You could certainly stop the service using T-SQL but would then have no way to start it again because the service would then be down. If you had a second instance running you could accomplish it but if you need to automate things I would suggest it is best to manage service-level functions, like restarts, using a tool like PowerShell.Tue, 01 Jan 2013 04:45:57 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1401431-392-1.aspx[quote][b]WolfgangE (12/31/2012)[/b][hr]of course you can. Depends on what property or configuration you actually want to change.Just to name an example, have a look at "sp_configure".Changing the name of a sqlserver can be done using sp_dropserver and sp_addserver. Just google for it.[/quote][quote]Have you learned about the Script button in SSMS? It will help you to review what will actually be run against your instance to ensure you know what is happening as well as help you save the change for later use in production after you have tested the change in a non-produciton environment Personally I never apply changes using the GUI's OK button. I may make the configuration change in the GUI but then I will always script it to a query window using the Script button and then Cancel the GUI dialog. Then, after revieing the script generated by the GUI, if I agree with the code and want to make the change I will run the script.Get script for every action in SQL Server Management Studio By Atif Shehzad [/quote]Thank you ... very very muchcan i use this to restart SQL service ...like that i Right click on Server name and Choose Restart.i want do this in T-SQL.Tue, 01 Jan 2013 02:01:11 GMTpooya1072http://www.sqlservercentral.com/Forums/Topic1401431-392-1.aspx[quote][b]pooya1072 (12/31/2012)[/b][hr]hican i change the properties of a server instance with T-SQL ...like Enabling mixed mode or change the name of server ?[/quote]Have you learned about the [i]Script[/i] button in SSMS? It will help you to review what will actually be run against your instance to ensure you know what is happening as well as help you save the change for later use in production after you have tested the change in a non-produciton environment ;-) Personally I never apply changes using the GUI's [i]OK[/i] button. I may make the configuration change in the GUI but then I will always script it to a query window using the [i]Script[/i] button and then [i]Cancel[/i] the GUI dialog. Then, after revieing the script generated by the GUI, if I agree with the code and want to make the change I will run the script.[u][url=http://www.mssqltips.com/sqlservertip/2179/get-script-for-every-action-in-sql-server-management-studio/]Get script for every action in SQL Server Management Studio By Atif Shehzad[/url][/u]Mon, 31 Dec 2012 15:05:14 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1401431-392-1.aspxof course you can. Depends on what property or configuration you actually want to change.Just to name an example, have a look at "sp_configure".Changing the name of a sqlserver can be done using sp_dropserver and sp_addserver. Just google for it.Mon, 31 Dec 2012 10:27:37 GMTWolfgangEhttp://www.sqlservercentral.com/Forums/Topic1401431-392-1.aspxhican i change the properties of a server instance with T-SQL ...like Enabling mixed mode or change the name of server ?Mon, 31 Dec 2012 10:16:50 GMTpooya1072