title: Renaming a column in MS SQL Server 2005
body: <p>What is the best practice when it comes to renaming a table column using SQL (MS SQL Server 2005 variant)?  This assumes that there is data in the column that must be preserved.</p>