Rename a Sql Server

How do you rename a Sql Server ?Check out the following article:

article (http://support.microsoft.com/default.aspx?scid=kb;en-us;Q303774)

Make sure you run sp_helpserver first and copy the information.|||How do you rename a Sql Server ?

Hopefully by following a good plan developed and verified by rigorous prior testing. In other words, cautiously. (This a very broad question to address in this format even with a great deal of additional very specific detail.)

There are many different ramifications with different versions i.e. ( 6.0, 6.5, 7.0, 8.0) as well as with different editions and all the possible different installation details (the service pack levels of mssql and the OS, the host OS itself, virtual and/or default instances, cluster types and members, federated servers, the machine integration into the network {MS domain, Novell env., member server, stand alone, and so on} etc., etc.)

None of that begins to address any issues your applications and / or their access methods may face. Generally, this is something you should fastidiously investigate the ramifications of e.g.(by testing on a dev server configured as closely as possible to your production server). Simply changeing the host server OS name and proceeding form there may be a fairly quick and painless process in your specific case; ==> BUT, it may also result in a very expensive disaster (depending on your specific installation, environment, downtime costs, etc., etc.).sql