Vladimir,

The best way to do this is to collect all the data from the user first even if it's for 4 or 5 levels, as you claim.  Then, do a...

Might as well bite the bullet while you're small...

Lock down the production database.  Remove SA, DBO, and DDL ADMIN privs from all developers and users.  Insist on code reviews and unit/itegration...

I think you may want to look into the reason for the backoffice DB starting up twice... that should not happen...

I concur with Remi... a simple polling job is not going to be any load on the server at all.  We have a couple that run using the undocumented but...

If the tables already exist, there should be foreign keys in the child tables (the "many") that point to the parent tables (the "one").

If not, then, as Sreejith suggested, you...

You can fool around with user names, if you want, but those can always be tricked especially when users make the mistake of sharing logins...

If your Windows network is setup...

This should do the trick... the SELECT is where the rubber meets the road... the rest of the stuff is just setting up for the demo of the SELECT...

--===== If...

Actually, I've resurrected some old code I was working on to make a WebTask that would make some pretty output... the output does not yet list the primary or other...

Not a problem... thanks for the feedback.

Nope... new columns always get added to the "end" of the table if you use just an ALTER.

However, if you go into Enterprise Manager to design the table (add the...

By the way (drum roll, please), congrats on the more than 7000 posts you've made

True enough... you won't be making a view out of it, for sure

Bingo!!

Yep... and you've nailed the key to it... exclusive access... now, what table(s) will a developer ALWAYS have exclusive access to?