I am working on procedures for creating a new server. One of the things I constantly have to do each time SQL is installed is enable remote connections. Is there a way to do this with T-SQL rather than using the GUI? I would like to have a script to do as much of the administrative stuff as possible. SQL 2005/2008 are the environments I am concerned with.