SEARCH RESULTS

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...

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...

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...

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...

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...

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...

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...

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...

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...

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 error 17803 The error 17803 occurs when SQL Server cannot perform some operation because there is no memory available to perform this operation. This is the error message text: "I...

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...

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 ...

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...

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...

Troubleshooting SQL Server 2005 Analysis Services problems (Part 2) If you have problems with SQL Server 2005 Analysis Services, review this troubleshooting checklist to find potential solution...

Troubleshooting SQL Server 2005 installation Should you have problems installing SQL Server 2005, review this troubleshooting checklist to find potential solutions. 1. Check the hardware requi...