Small table, fewer than 100 rows.  Yes a toggle situation; 1 or other of the fields is populated, depeneding on error condition or not.

I would first make certain that the collation bwteen the servers is the same and the the Distributed Transaction Coordinator is running on both servers.

Each server needing connection to the new linked server should have its client network utility updated to a common name chosen as a alias and that name used as the...

SQL Server 2000 has a built-in role named TargetServerRole which has built-in permissions to see and run jobs.  Add the role to MSDB and then add the user to the...

You might want to check to see what ODBC software the DB2 is cataloged for on the DB2 server. Somestimes, like iSeries, it's the only one that will work.

http://www.sqldts.com/?242

The above link is for a DTSBACK2000.  Works great!

I would add a predecessor statement like:

exec Master..xp_CmdShell 'NET USE \\server\sharename <password> /USER:<DomainName\Username'

You should use the Client Network Utility on Server 1 to alias the remote Server 2.

If you are using TCP/IP address as Server 1 name, enclose it in square brackets...

There may a difference between the versions of DTS running on your server and your PC.

SELECT CVERUT, SUM(ENE) AS ENE, SUM(FEB) AS FEB  FROM TABLE GROUP BY CVERUT

Are the indexes on the same file group as the data?

Are the indexes on a separate filegoup on a different drive?

see the following:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_con_07_3w6r.asp

Check the reference to Microsoft ActiveX Data Objects and make certain you are using a library version which supports the stream object ( 2.5 or higher )

You can run sqldiag.exe from the command line. It will give you all ( and more ) the information you may need.

I noticed your query string contained a .. in the

attributions. Try filling in the catalog name bwteen the ..