01 December,2012 by Jack Vamvas
When making a SQL Server configuration change – I prefer to produce code rather than complete through the SSMS GUI. There are a number of benefits for producing the code as opposed to completing the task through SSMS
1) In a Production environment , most change request systems require the code attached to the change request. This allows an approver to check the code
2) If troubleshooting is required , sharing the code with other developers\DBAs is easier for them to understand the problem. Don’t forget , if posting to a forum – don’t include any sensitive data
If you don’t want to write your own code – you can simply use the Ctrl+Shift+N , instead of clicking the OK button.