Blog is a collection of misc troubleshooting tips collected while supporting Microsoft SQL Server 2000, 2005, and 2008. Specialty area covered is SQL Server Data Replication including Transactional Replication, Merge Replication, Change Data Capture, and Change Tracking. Forcus area covered include SSIS, Performance, and Replication

April 2009 - Posts

• How to create a SQL Server link server with a different name.

  If select SQL linked server in the GUI you can't specify a different name for the SQL Server. You can only use the SQL host name as the Link Server name. Here is an example of creating a Linked Server via script to specify link server name myGX620 for Read More... Posted Tuesday, April 07, 2009 11:16 PM by chrissk | 1 Comments Filed under: sql 2005 2008 linked server