Need more information about each schema to help you write the code directly, but here's the short form:

SELECT

-- all fields except identity

FROM

-- duped table

GROUP BY

-- all...

The only way I can think of modifying the schema components is to open it as XML, find/replace, then reload the XML. Sorry, I just brainfarted on the fact...

You'll get no performance increases from their removal, but you'll probably get readability and maintenance improvements from having less objects to keep track of.

EDIT: I should say no significant performance...

I'm assuming you've tried this, but have you thought about beers after work with these people, individually, and having a frank discussion about what you're percieving? I'm not saying...

If possible, can you offer a lot more detail into the data status on the two databases and future intent?

If you're looking at a complete overwrite on one of the...

Yes, but you have to prep to do it from the start, using configurations. However, in theory, you should only need to change the Data Source object. What...

dogramone (12/3/2012)

---

And unfortunately none of them are intelligent enough to investigate. Oh for the good old days when IT was a black box that no one got involved in...

Perhaps, but honestly I was hard pressed to answer your...

*wipes away a tear from his eye* Damn, Jeff... that's... that's just beautiful. *sniff*

I couldn't for the life of me figure out how to get out of the...

You've answered the data, not the problem, with this. You cannot recurse in both directions, you cannot deal with more than 2...

capnhector (11/30/2012)

so far an extension of my adjacency list by searching up and down (not the fastest thanks Mickey T. by the way) and dwains loop solution are the only...

Sarwan (11/30/2012)

---

I have also escalated to our infra team for any n/w port issues between websites hosting webserver and backend database server but they didn’t find any errors.

Can you...

Typically I do it for merge replication. Considering how much I try to avoid that particular method of replication, I don't do it much.

Olly, a question before I work this code.

First, you put in 0-length strings, '', instead of NULLS where teh data is missing for PRVID/PrvName. Are these NULL, or actually...

My pleasure. Sounds...