Check out this article: http://www.sqlservercentral.com/articles/Integration+Services/61542/

..... getting out the reciprocating saw .... or will that cause too much damage where the handrails are installed...

Good advice for Lynn also.

Jeff Moden (6/14/2009)

---

Also, test the restoration of backups and maybe write the standard guidline for doing such a thing. Maybe even go whole hog and setup/test a disaster recovery...

This article http://www.sqlservercentral.com/articles/Integration+Services/61542/ dynamically creates tabs in an excel spreadsheet and exports data (from a select statement) into it. It is designed to run from within SSIS. Note that I...

Jeff Moden (6/14/2009)

---

Heh... another one. I didn't say it would give a "forever" log and didn't write the code that way. I wrote the code to give a...

Jeff Moden (6/14/2009)

---

You've added a line of code the OP didn't have in the original problem and that new line is the one responsible for the incorrect operation.

echo %date% %time%...

Gail, I...

info (6/13/2009)

---

I need to make 100 or so tables. I have tables called PartStatsXXX and the tables to be made will all be called PartReviewXXX. Some PartStatsXXX tables have corresponding...

Okay, here's some code to demonstrate what I'm talking about.

Save this code as a batch file, and run it:

for %%a in ("%windir%\*.exe") do SQLCMD -S ServerName -d master -E -Q"set...

Everyone that keeps posting is just helping to keep "forumloser" around. I suggest that everyone refrain from posting anymore to any of the threads that he has posted to.

At this...

You could try putting the two queries into a procedure, and then specifying to execute that procedure as the query. That may do the trick.

You know, the people that help out here are all un-paid volunteers. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables affected, and INSERT statements to put...

Ahem. It's not very often that someone gets to tell...

RBarryYoung (6/12/2009)

---

You know, I've always wondered why the #Temp tables that we create in SSMS (or QA) don't get destroyed when the batch/request ends. Shouldn't they run out of...