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.
In SQL Server 2008, you should be able to re-create your index and drop the existing one in a single command-try this: The WITH DROP_EXISTING should drop the old index with the included columns. Once that command has been run, you should be able to drop your column from the table.