Found this, maybe?

http://groups.google.com/groups?q=%40%40servername+for+your+export+server+is+invalid&hl=en&lr=lang_en&ie=UTF-8&oe=UTF-8&selm=7evq2r%24m1s%241%40uuneo.neosoft.com&rnum=2

http://groups.google.com/groups?hl=en&lr=lang_en&ie=UTF-8&oe=UTF-8&threadm=813efn%24tj5%241%40newsreader2.core.theplanet.net&rnum=5&prev=/groups%3Fq%3D%2540%2540servername%2Bfor%2Byour%2Bexport%2Bserver%2Bis%2Binvalid%26hl%3Den%26lr%3Dlang_en%26ie%3DUTF-8%26oe%3DUTF-8%26selm%3D813efn%2524tj5%25241%2540newsreader2.core.theplanet.net%26rnum%3D5

Andy

http://www.sqlservercentral.com/columnists/awarren/

What are you browsing? If its any db object, it will work that way for whatever server you've connected to.

Andy

http://www.sqlservercentral.com/columnists/awarren/

Chris, I think we should definitely get this into an article and really make sure we answer the questions Jeff posed. Voodoo (or seemingly voodoo) like this can cost you...

Mark, I'm a little late, but let me add our thanks as well. I know those posts take time and they add up to an incredible value for those that...

I totally agree with both and I'll move that way up on the list (just under shipping the book to inquiring readers!).

Andy

http://www.sqlservercentral.com/columnists/awarren/

We're glad we can help where we can. Thanks for the kind words.

Andy

http://www.sqlservercentral.com/columnists/awarren/

Yes, is standard in SQL2K and no way to turn off that I know of. Agree that changing your proc (look at ecid for the parallel threads).

Andy

http://www.sqlservercentral.com/columnists/awarren/

Point #1 made by Chris is superb - if you need cross db integrity (think about doing a restore of a single db) you'll do a LOT of work to...

So it's a connectivity/resolving issue. If it doesn't connect based on IP, my first thought is that you're only running named pipes maybe, or that you've got a problem with...

I've been lucky(?) enough not to run into this so far. I'd rather run a single instance unless the security needs of the app would preclude that. For instance, recently...

Wow, what did 23k seats cost? I'd consider it a paper change (dont know about MS!).

Andy

http://www.sqlservercentral.com/columnists/awarren/

Does the like have a leading wildcard? That will cost a lot more than just trailing wildcard. Do you have indexes on the join columns? Looked at a query plan?...

It's a shame they don't make it easier/more transparent, its such a common task.

Andy

http://www.sqlservercentral.com/columnists/awarren/

Either way you'll have to transfer the logins too (separately) or add them manually. If you do the latter you'll need to run sp_change_users_login to fix up sql users in...

Is full text search an option?

Andy

http://www.sqlservercentral.com/columnists/awarren/