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.
For that you will have to link the second server to your first current server using linked servers option in enterprise manager or using the stored procedure called sp_addlinkedserver. Then in your query you can use tables of the remote server by qualifying the table name with the linked server name.o run a query over a linked server. select * from [server name].[database name].[owner name].[table name]. Popular Q&A contents include summarized information from SQL Server discussion unless otherwise noted. Join the sql-server-l group and participate in discussion on this topic.