I would suggest, however, to try using the local system account to see if that "fixes" it. Then we know we had the same issue.

I feel confident that the...

I was never able to track down the exact issue. Rather, in time I rebuilt the server and it worked fine. My theory related to the issue is that there...

Further work on this problem has shown that on this particular SQL 2005 server, if the agent is not running under the same account as the SQL Service account, then...

If you enter:

select *

from master.sys.sysservers

where srvname = 'repl_distributor'

...does it reference the correct server's name or the old server's name?

You'll want to load the spreadsheet into a staging table and load it into the table with the identity value from there.

Does the spreadsheet have values that go into...

First of all, I'd like to thank those who replied. I really appreciate the input.

David - Thank you very much for your note. That is a fantastic point...

I'm with you Jeff, this is most definitely a puzzler. There are no missing indexes. Both in production and in all my tests there is one table locally (maybe 5000 rows) that...

Hi Jeff.

To answer your last two questions, the answer is "yes", that was a part of the test plan. The problem was evident when code that had been working...

Yeah. That's a good suggestion. I've tried everything I could think of in those lines. DBCC reindexes, using "update statistics" on all tables affected. sp_recompile on affected tables, etc. Something...

Hi Jason.

Thanks for the reply. The question you ask is a great question and one of the first things we experimented with. The problem is more then a simple SP4...

I thought I'd post follow-up so that this was added to the library of documentation available on this site.

Interestingly enough, I jumped the gun on thinking that

exec sp_setnetname...

Hi Moreno.

Thanks for the reply. As mentioned, this isn't something that simple. The problem is currently limited to linked server. All connectivity directly to the virtual name, not including...