Ummmm - I believe a resolution was attained 4 months ago (and your suggestion was more or less proposed 6 months ago!).....but that's just me 😀

Homework/project - what's the difference?? You mentioned msdn. Here's the link. Use a query to get the data that you need. If you make a honest effort and get stuck,...

FYI - Upon further investigation of the servers and interrogation of the former DBA, I found out these were remote servers created several years ago. They're history now!

Does it have to be bcp or can you use some of the native SQL tools like DTS? DTS can do this very easily.

Thanks Manu! Sometimes the obvious proves elusive. In the words of the immortal Homer Simpson - "DOH"! sp_dropserver did the trick. :blush:

Google yielded this, among others. Some interesting stuff that may help you solve the mystery.

http://www.sqlservercentral.com/articles/Administering/howtousetraceflagsinsqlserver2000/1860/

I'm running SQL2K sp4 and this message is not in my logs, even after a server restart. Possible it's in your startup parameters?

Hardware is most always the culprit. Check your event logs for disk errors and run hardware diagnostics to see what causing your corruption issues.

Thanks. I've already run one of the scripts and it created the job fine. Again, paranoia on my part - I think because it seemd too simple (good ole' MS!)....

Upon closer inspection, it appears it does want to ADD the steps, not execute them. I'm very skittish with these two jobs because there are references to linked-production servers within...

Any maintenance jobs running (index rebuilds, checkdb)? Large adhoc or runaway queries? Is the tempdb set to autogrow? The log file seems awful small for tempdb (.59 mb??) with 24Gb...

Nope, using IE. Deleted temporary internet files and all is good. Hate doing that because I lose all my "remember me" logins and now have to re-type them. :crazy: I...

That's what I was doing, searching for a recent script. Based on another topic, Steve stated he had approved/posted two new scripts. I couldn't find them but as I was...

I'm trying to picture the difference between an inner join and an outer join, (outer join sounds painful)....or a one-to-many join - woohoo!! Seems like the possibilities could be endless...

Mark, you've got a pretty good handle and argument for why you shouldn't be doing what you obviously, short-term, have to be doing. SQL Server does not tolerate latency very...