Elliott W (9/14/2009)
Provided the severname doesn't change all that will likely be needed is a restart of the services to use the new ip address..CEWII
This option of servername will only be valid if you are connecting sql server using servername rather than IP. I have seen some people using IP rather than server name.