It's used in our client app's ODBC connection. The thought process being, if we have to fail over to our DR SQL server, we can update the alias in DNS to point to the new IP.

Is it possible to have a SQL Server 2005/2008 instance respond under multiple "aliases" for the same server.<BR><BR>Eg.