blake colson (10/1/2008)

SOLUTION: UPDATE STATISTICS on key table used within the query. My query returned in < 10 seconds where before I was killing it after 10, 20,...

I was able to resolve this issue by deleting all the indexes with hind_ prefix in the sysindexes table in the affected database.

Yes the index are on the same physical file as the tables. This is not a clustered environment. It's Windows 2000 and SQL Server 2000 SP4.

Yes, the linked-server user has appropriate permissions. Also when I dropped all the indexes on the table the query worked. On re-creating the indexes the error resurfaced.

Did you find the answer to this issue? I am currently experiencing the problem as stated here? Anyone?

I ran into this error just today, also from an MS Access linked table to SQL Server.  Running DBCC INDEXDEFRAG on the SQL Server table fixed the issue.

The message is not from DTS but from SQL Server Agent job. View the job history and click the "Show step details" checkbox.

I came across same issue (see my previous post at) http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=182428

This was happening on a dual-processor server and does not occur on a single-processor server after SP4 upgrade.  Setting...

I had SQL Server 2000 SP4 installed on development and QA servers (mixture of Win2k and Win2003 servers) for about six weeks before I upgraded all of our production servers...

If you want to use SQL Server authentication create a SQL login named honlot and update your first connection string to include the password.

To change the protocol to TCP/IP on...

You don't have to do anything.  All users should be able to create/modify/run their own DTS packages unless of course, you have revoked permission to all the DTS stored procedures...

Could you post a snippet of your textfile creation step?

To completely lock down your DTS sub-system, go through the system stored procedures in msdb and revoke execute permission to public on any procedure that has dts in its name.

Then...

Couple of things you should check:

1. When you create the package use UNC path to the text file instead of absolute path.

2. When you schedule the package change the job...

A more dynamic approach is to use Dynamic Properties Task reading the server name from an INI file and setting it to a global variable.  You could then have the...