The Undertaker, whose real name is Mark Calaway, wishes Sting the best of luck and is reportedly looking forward to facing the pro wrestling legend in the ring. Calaway's intention to face Sting in the ring has lead many wrestling fans speculating that the WCW superstar will face The Undertaker first.
To rename a column using Object Explorer. In Object Explorer, connect to an instance of Database Engine. In Object Explorer, right-click the table in which you want to rename columns and choose Rename. Type a new column name.
This is the main step that you need to take for creating new instance in installed SQL Server 2008 R2. Select option Named Instance from the given option and provide the name as per your wish for new Instance. In my case i have given name as MYSQL and clicked Next button.