Home Forums SQL Server 2008 T-SQL (SS2K8) is it possible to change an instance server properties with T-SQL ? RE: is it possible to change an instance server properties with T-SQL ?

  • pooya1072 (12/31/2012)


    hi

    can i change the properties of a server instance with T-SQL ...like Enabling mixed mode or change the name of server ?

    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[/url]

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato