Wasn't there a thread (or two) recently on temp tables vs. table variables? I recall the gist was SQL Server implements them similarly, so you don't really get any...

Do you want the next date if it's a weekend day? Your original post said business date. If you add ten hours to the time of orders after...

Danger is my middle name.  How about:

ALTER TABLE Table1 ADD CONSTRAINT FK_Table1_Table2 FOREIGN KEY

            REFERENCES Table2 ( LastName )

            ON DELETE CASCADE

Thanks, guys, I'll have to file this one away for later use.  Our DBA swears that we have mysteriously flipped on a global setting.  Our "alpha" programmer has ordered that...

It sounds like you are saying that because of the SCHEMABINDING, I need to have all these (required for views with indexes) set:

SET ANSI_NULLS ON

SET ANSI_PADDING ON

SET ANSI_WARNINGS ON

SET ARITHABORT...

Kenneth:  Given that the other procs don't reference this view, what are the correct settings?  I believe we have ARITHABORT ON and we tried QUOTED_IDENTIFIER ON and OFF.  But it shouldn't...

You can use BULK INSERT in T-SQL to load the file into a temp table.  There are plenty of good threads here on BULK INSERT.

Remi:  You're right, how would systems function if anyone could turn off logging?  It would be like driving while talking on the cell phone; I know I can do it...

"A data extract thingie"??  Is that how the statement of work was worded?  That's how the State of California does theirs. 

mom: "I just hope technology would help them learn to be a smart, bright and loving children."??  Nope, that's your task.  Oh, and mine, and Steve's, and Celko's (bless his heart). ...

It looks like you have multiple select statements in your script.  If so, you will always have those header rows.  You might insert the count results into a table variable,...

DTS will work just fine.  I base the design decision on whether to do that from DTS or from code in a stored proc on where it needs to be...

Look in BOL, but also search this forum for "bcp" and "queryout".  There are some really good threads here on this topic.  If you get stuck, post again.

And wouldn't that be a fun one to debug? 

We script all changes from dev to QA.  If someone adds a column, they generate an ALTER TABLE script.  Stored proc changes are also scripted, with a DROP then CREATE...