There are many ways Hep C can be spread, including: 1  Recreational drugs that involve needles or straws. 2  Sharing personal care items like razors or toothbrushes. 3  Needlestick injuries in healthcare settings. 4  Sexual contact with a person infected with the hepatitis C virus. 5  Getting a tattoo with unsterilized equipment.
To create a linked server (SQL Server 2008). Click Start, click All Programs, click Microsoft SQL Server 2008 R2, and then click SQL Server Management Studio.In the Connect to Server dialog box, specify the name of the appropriate SQL Server, and then click Connect.In SQL Server Management Studio, double-click Server Objects, right-click Linked Servers, and then click New Linked Server.o create a linked server (SQL Server 2008). Click Start, click All Programs, click Microsoft SQL Server 2008 R2, and then click SQL Server Management Studio.
MSDN Reference for Add Server http://msdn.microsoft.com/en-us/library/ms174411.aspx. As said in the article, This procedure must be executed on all instances of the Database Engine hosted on the computer. The instance name of the Database Engine cannot be changed. On the SQL Server instance, run the following query. sp_dropserver '<oldservername>'. go. sp_addserver '<newservername>', local. go. Now restart the SQL Server related services. Then, run @@servername to verify if the new name has been updated.