I'm sorry, but I can't understand what you're asking.

That's part of your production data pipeline. You can't use Dev Edition for that.

Nope. Would violate basic database ACIDity, because the transaction wouldn't be atomic.

Search online for "string concatenate for xml". You'll find good solutions with that.

SQL Server has to make sure every action in every IF can be executed. Your script won't run, because pieces of it can't be run, so you get that...

Change "print" to "select".

Dev Edition can do anything Enterprise can do. You just can't use it for anything except development and testing.

Are you inserting via T-SQL, SSIS, or some other means?

In T-SQL, you can use Left() in your Select to cut it off at 50 characters.

In SSIS, you'd use a derived...

Do you have a trace that will capture the commands and where they got to? That might help you start out.

I'd definitely look at logging the dynamic commands before...

Grant Fritchey (11/30/2010)

---

Jeff Moden (11/30/2010)

---

Changing subjects, have you seen today's featured script? It comes under the category of "Are the featured scripts getting worse"? I try to be...

Just to add another vote for NOT using this. There are MUCH better methods than stepping through with a string function in a loop.

Also, in current versions of SQL...

WayneS (11/29/2010)

---

GSquared (11/29/2010)

---

Wayne, just because a table has an ordered clustered index, doesn't mean an identity column will honor that order. Usually it will, but you can't guarantee it.

Jeff's...

mister.magoo (11/30/2010)

---

Brandie Tarvin (11/30/2010)

---

mister.magoo (11/29/2010)

---

@Brandie and GSquared,

There were additional requirements in the OP's question - and while it is helpful to have your excellent input, you are not addressing the...

Ninja's_RGR'us (11/24/2010)

---

Geoff A (11/24/2010)

---

GSquared (11/24/2010)

---

Ninja's_RGR'us (11/24/2010)

---

GSquared (11/24/2010)

---

Per-processor is how most multi-user installations are done. CALs are mostly useful to very small shops with a small number of people accessing...

Craig Farrell (11/29/2010)

---

CirquedeSQLeil (11/29/2010)

---

GilaMonster (11/29/2010)

---

In other news...

The project from hell (the one that I spent evenings, nights and weekends on to try and meet impossible deadlines) has had the go-live...