SEARCH RESULTS

Home  >  Search Results

86443 results found for "linked server" in order of relevance.

Only the top 100 results are shown. Refine your search for a smaller result set.


Updating Results
Updating Results
Total Results:100 - Showing Page: 1 of 6 << < > >>
Troubleshooting Linked Servers in SQL Server 2005 (3/5/2008)

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 (6/16/2009)

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 (11/9/2006)

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 (11/19/2008)

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 Your Data - Part 1 Creating a Linked Server (2/2/2007)

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 (4/27/2004)

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 (4/16/2008)

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 (9/6/2006)

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 (4/26/2006)

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 (8/17/2005)

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 (5/25/2005)

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 (3/7/2007)

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 (7/27/2005)

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 (5/19/2004)

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

[Msg]: Re: [SQL2K5] Linked Server Error SQL Server 2005 Cluster. (5/8/2009)

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

[Msg]: RE: [sswug:sql2k] Linked Server Driver for SQL 2000 to SQL 2000 (3/5/2003)

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 (5/12/2004)

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

[Msg]: RE: [sswug:sql2k] Linked Server Driver for SQL 2000 to SQL 2000 (3/5/2003)

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) (10/1/2008)

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 (12/6/2006)

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