What dimensions to you already have?  If you are trying to model these tables for a generic survey with a variable number of questions it may be difficult to get...

from the use of VARCHAR2 I'm guessing they are using Oracle, but Oracle has supported INNER JOIN and OUTER JOIN syntax since version 9i

In both of these options you have a many-to-many relationship between FormHeader and CatelogHeader in the intersection table CatalogForm.  The difference between your 2 proposals seems to be if the...

If the user is an active directory user, it's also possible that the user was created based on their membership in an active directory group that has a login.  SQL...

Glad you figured it out, you may want to learn the more modern join syntax though, where the join conditions are specified within parts of the FROM clause instead of...

I think he meant the TABLOCK hint, like in his original response:
INSERT INTO dbo.table1 WITH (TABLOCKX)
That is what will ensure minimal logging.

Since all we...

There are (very few) things that would write to the transaction log in Minimal Logging mode if the database is in SIMPLE recovery compared to FULL recovery mode, but as...

Setting up a linked server with ADSDSOObject probably won't work with Case 2, I believe the "be made using this security context" option is designed for use with SQL Authenticated...