title: SQL server command to create server alias?
body: <p><a href="http://msdn.microsoft.com/en-us/library/ms190445.aspx" rel="nofollow">MSDN</a> states that there are 4 steps in creating a server alias:</p>
  
  <blockquote>
    <ol>
    <li>In SQL Server Configuration Manager, expand SQL Server Native Client Configuration, right-click Aliases, and then click New Alias.</li>
    <li>In the Alias Name box, type the name of the alias. Client applications use this name when they connect.</li>
    <li>In the Server box, type the name or IP address of a server. For a named instance append the instance name.</li>
    <li>In the Protocol box, select the protocol used for this alias. Selecting a protocol, changes the title of the optional properties box
    to Port No, Pipe Name, or Connection String.</li>
    </ol>
  </blockquote>
  
  <p>But instead of doing it the "UI way", is there a SQL command to do it?</p>