Good points. I assume these concerns would normally be handled in the web service (assuming SQL Server was not involved). If SQL Server was utililezed to implement, how...

yes, it helps. thank you. i will also investigate other gotchas.

What are the pros and cons of implementing from the DB server as opposed to a client application? Security? Performance? Operability? Thanks in advance.

Thanks Rich. That is exactly what all of my research has returned.

Thanks. I did look into CTEs; however, because a child node may have multiple parents at different levels of the hierarchy and the fact that I did not have...

Thanks.

Thank you.

The volume is small on each member instance.  So you are suggesting a composite primary key that consists of an Identity column + another column that would create uniquness.  That sounds...