SEARCH RESULTS

Microsoft Access 2003 Linked Server on SQL Server 2008 using the JET and MSDASQL Providers For accessing geographically distributed data linked servers provides a good solution. MS SQL Servers alw...

Troubleshooting Linked Servers in SQL Server 2005 If you have problems with SQL Server 2005 linked servers, review this troubleshooting checklist to find potential solutions. 1. Insta...

Working with Linked Servers by Bill Wunder Linked servers allow you to query virtually any OLE DB data source from T-SQL running on a SQL Server 2000 creating a tremendous backdrop fo...

Implementing Linked Servers on Microsoft SQL Server 2005 for Accessing Data on Remote Oracle Servers By Rocco Mastrangelo This article describes how to use either the Microsoft SQL Ser...

Consolidating Data With a SQL Server 2005 Database By: TRACY ROOKS Part 1: Setting Up a Linked Server With a Legacy Database In the past year I consulted on a project to replace a rather l...

SQL Server 2005 Linked Servers Optimization Tips Try to avoid using distribution transaction or minimize it using. Because distribution transactions incur more overhead than general transacti...

Useful undocumented SQL Server 2005 distributed queries stored procedures SQL Server 2005 supports the following useful undocumented distributed queries stored procedures: - sp_linkedservers_ro...

Troubleshooting Distributed Queries Procedures SQL Server supports the following thirteen distributed queries procedures: - sp_addlinkedserver - sp_indexes - sp_addlinkedsrvlogin - sp_linkedser...

Troubleshooting Linked Servers If you have problems with linked servers, review this troubleshooting checklist to find potential solutions. 1. Check that you use the latest SQL Server service ...

Known SQL Server service packs problems Usually SQL Server service pack fixes all known bugs, but sometimes it can produce new bugs, which fixed by next service pack, and so on. In this article, y...

A linked server is just a definition for how to connect to a server. The server (Server A) on which you use the linked server is a client of the SQL instance (Server B) that the linked server repres...

Adi, Thanks for all the info. We are using the four part name properly as we commonly select data from one of many linked servers. We ran into a problem when we attemped to perform an update (o...

Useful undocumented SQL Server 2008 distributed queries stored procedures SQL Server 2008 supports the following useful undocumented distributed queries stored procedures: - sp_catalogs_ro...

Linked Servers Optimization Tips When you create a SQL Server linked server, use 'Microsoft OLE DB Provider for SQL Server' instead of 'Microsoft OLE DB Provider for ODBC'. The OLE DB Provider f...

If you select in the linked server dialog SQL Server as the server type, then it will use the OLE DB Provider for SQL Server (you can check the SysServers table). When you issue any SQL state...

Tips for using SQL Server 2008 Distributed Queries Try to avoid using distribution queries or minimize it using. Because distribution transactions incur more overhead than general transactions...

Troubleshooting SQL Server 2005 Management Studio If you have problems with SQL Server 2005 Management Studio, review this troubleshooting checklist to find potential solutions. 1. Insta...

Troubleshooting SQL Server Command Prompt Utilities If you have problems with SQL Server command prompt utilities, review this troubleshooting checklist to find potential solutions. This article c...

Troubleshooting SQL Server Network Libraries and Protocols 1. Check that you use the latest SQL Server service pack. Because many SQL Server network libraries and protocols bugs were fixed in...

Communicate with Linked Servers - SQL SERVER 2005. (Deepankar Bandopadhya) Communicating with Linked Servers is a common business scenario. The Linked servers can be located ...