The server is Windows 2008 R2 64bit. The SQL instance is SQL Enterprise 2008 64bit. I'm not sure about the DB2 and Oracle drivers, but they show up...

I have also tried editing the Connection String for my As400 connection in the Job Step Properties page within the Scheduled Job, but that did not work either, and it...

In the SSIS package, the AS400 connection is set up as an OLE DB data source, using the "IBM DB2 UDB for iSeries IBMDA400 OLE DB Provider" driver. In...

Good article ...

I use linked servers alot and have had performance issues as well, however my queries did not return a whole lot of data (they just took long to...

I feel you pain ... we have over 200 SQL Server 2000 instances that need to be monitored, and not just for SQL job failures.

The solution I went with works...

I had similar issues with running linked server queries. I ended up writing stored procedures on the linked server, and called the stored procedures instead of running the queries...

To all: Is it possible to install only SSMS from the SQL Server 2005 installation disk? We need to provide SSMS to about 30 users via Citrix, and we...

Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86)

 Mar 23 2007 16:28:52

 Copyright (c) 1988-2005 Microsoft Corporation

 Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

Note: I installed SQL2005...