Yes, you are supposed to plug those in.   This is why I always use the wizard instead, so that I know exactly what it needs right as it needs it.  ...

Most of the reason that it doesn't "come up" is because those organizations that need it have well established ETL processes where the right person can easily track down all...

Interesting concept.   However, without a lot more detail, it's somewhat difficult to make a useful recommendation.   I'm not any fan of EAV designs, as they are the very worst when...

There's a simple option that can be set that will "solve the error message", but the performance may be problematic.   Use this with caution:

OPTION (MAXRECURSION 0)

This...

SQLCurious,

Just an FYI, but what you described with your pictures is known as an EAV design, or Entity, Attribute, Value.   For database querying, it's pretty much the worst...

Lowell,

Here's something I found on Stack Overflow:  http://stackoverflow.com/questions/10637976/how-do-you-check-if-identity-insert-is-set-to-on-or-off-in-sql-server

Two possible ways to answer this.   But first, why do you want to "pollute your inputs" ?   If these times are coming from the past, inferring a current seconds value...

Lowell,

Is there a simple query to determine what table has that property turned on ?

That's kind of like asking me to call balls and strikes on pitches already made to the plate that neither of us has seen.   You've said nothing about HOW that...

Cool beans... . Look up the term "covering index".   That's what a good index does.