Improve performance on Insert rows into DB2 400 table from SQL server
Using INSERT OPENQUERY and a linked server on SQL Svr 2005, to insert rows to DB2 table on AS400. To a local AS400 runs very quickly. Performance on a remote 400 is very slow, and seems to be out of proportion to the change in line speed. Is there anyway to improve the performance for [...]

Answer Question   |  October 29, 2010  2:58 PM
AS/400, DB2/400, Linked servers, SQL Server, SQL Server 2005

Creating DTS package for Linked Server database
There is a linked server database for which packages are to be created using DTS wizard. Please can anybody help me by telling how to create packages. Thanks

Answer Question   |  February 6, 2009  3:53 AM
DTS Import/Export Wizard, DTS package, Linked Server database, Linked servers

Linked servers from SQL 2000 to SQL EXPRESS 2005
I wanted to create a linked server on SQL SERVER 2000 to SQL EXPRESS 2005.Both servers are on the same machine .SQL SERVER 2000 using username and password while SQL EXPRESS using integrated security.Thanks in advance.Any one let me know how to create this?

Answer Question   |  December 15, 2008  4:51 PM
Linked servers, SQL Server 2000, SQL Server 2005, SQL Server Express

Linked Server Query Returns Incomplete Results
I have set up a linked server using Microsoft OLE DB Provider for ODBC Driver to an Oracle DB ODBC DSN. The Oracle table I’m querying has 865 rows but when I try to fetch all the rows I only get back 766 rows. Why am I not getting the complete results? Here is the [...]

Answer Question   |  January 6, 2011  12:42 PM
Linked servers, ODBC, OLE DB, Oracle Database

Error message while querying a linked server SQL database
We have two remote servers, both with SQL Server 2000 databases. An ODBC data source was setup on the first server to point to the SQL Server database on the second server. Also, a linked server was setup on the first server between the SQL Server databases on both server. It was based on the [...]

Answer Question   |  October 23, 2008  6:37 PM
Linked servers, SQL Server 2000, SQL Server 2005, SQL Server database, SQL Server errors

Linked server error message on a SQL Server 2005 machine
We are installing a vendor-developed application that requires linked servers between the vendor database’s server and many of our other servers. It has been set up and tested effectively, but it should be noted that it is a double hop to the servers. Server A (which houses the application) queries the linked server defined on [...]

Answer Question   |  September 16, 2008  3:25 PM
Linked servers, SQL Server 2005, SQL Server errors

Reindex DBF file from Ms-SQL 2000
Is it possible to reindex an extenal dbf file via linked server ?

Answer Question   |  August 18, 2008  9:51 PM
DBF file, Linked servers, SQL Server 2000

Linked Servers????
Hi everybody, I’m an IT student and i’m doing professional practices. A simple project was assigned to me. This company uses SMS to collect information of all his PC’s and stores this information in a MSSQL database. A manager checks this information and fills another database located in another server. For example, in the SMS [...]

Answer Question   |  July 4, 2008  3:51 PM
Database, Enterprise Manager, Linked servers, SQL, Windows Server, Windows Server 2003

run DBCC SQLPREF on linked server.
I want to run DBCC command on linked server remotly

Answer Question   |  May 23, 2008  10:05 AM
Database Consistency Checker, DBCC, Linked servers, SQL Server administration