Rod at work (2/14/2014)

---

Mauricio N (2/14/2014)

---

I've used VMWare Player (now Player Plus) and VirtualBox. Both are good, unfortunately it's not so easy to change from one to another (I've tried...

James Horsley (2/14/2014)

---

I mainly...

If there are many tables use this script:

DECLARE @sql varchar(max),

@Database1 varchar(50),

@Database2 varchar(50),

@TableName varchar(50)

SET @Database1 = 'Production'

SET...

You can make a procedure obtain tables name for sys.objects like this

select a.id, a.name

from sysobjects a

where xtype...

It is not wrong to make a relationship of several predecessors and successors, but his logic contradicts the desired result, as with row 3 and 5 for example.

I'm just...

I think your table definition and table data are wrong. Or may be I don't know in what case use your case.

That's because in a normal situation that includes parent/child...