Tom.Thomson (3/22/2010)

---

This was already a good idea back in the 1960s. Of course people had to communicate by telex or paper mail back then, but it was already known that...

Where I've seen that before, it's been an issue with creating the encryption certificate. Have you done that?

Then it's definitely security. If they can find each other, then it's not "does not exist" and is "or access denied".

Are you using SQL security at both ends, or...

I'd check DNS next. "Server does not exist" may mean it can't resolve the name.

Can you ping the servers from each other?

RedGate's SQL Refactor can do table splitting for you, but it might have trouble biting off that many rows all at once.

I have a copy of SQL 2008 Dev Edition installed on Vista Ultimate at home. Includes SSRS, SSAS, and all the rest.

You just have to patch it up to...

I'm curious how this saved you "many hours of work".

GilaMonster (3/19/2010)

---

GSquared (3/19/2010)

---

Well, I get to tell stories about riding a horse home through the woods at 40 degrees below zero with enough wind-chill to make spit freeze before it...

You're welcome.

So long as it was an option, I think it would be a good idea.

Of course, as a workaround, you can restore as a different name, then issue a drop...

I have to agree with Jeff on the point of not changing data in a production system without external validation.

I've run into that exact situation, a 29 Feb in a...

The Local Name option is the only one I know of for this that would work in a query. I've used it, and it does work, but it can...

Is it possible that any permissions have been changed? If so, you'd be able to log in, and that would make the linked server not give a security error....

Can you provide table definitions for the tables the view selects from?

Ray Laubert (3/19/2010)

---

I have to take acception to one of the comments above. The selection of simple vs full is not made based on when you do a full...