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.
To resolve this error, you can either modify the connection string to use the server name or you can enable TCP/IP for the service. 1  Follow these steps to enable TCP/IP: 2  Start SQL Server Configuration Manager. 3  Expand SQL Server Network Configuration. 4  Select Protocols for MSSQLSERVER. 5  Right-click TCP/IP, and select Enable. 6  Select SQL Server Services.