I had my code review...it didnt go so well. The revisions I need to make are;

If StandardColumns has no list of columns for a table, then all the source columns...

morepainot (8/8/2012)

---

Lynn Pettis (8/8/2012)

---

Turns out the space may not matter (tested here at home), but the parens violated the ALTER TABLE syntax.

Regarding the space, it may really come down to...

Jeff Moden (8/8/2012)

---

??? :blink:I thought you said you didn't have anyone who could...

Lynn Pettis (8/8/2012)

---

Turns out the space may not matter (tested here at home), but the parens violated the ALTER TABLE syntax.

Regarding the space, it may really come down to being...

Lynn Pettis (8/8/2012)

---

Hoping you are working on this, but thought I should post what I have done.

DECLARE @SourceDatabaseName NVARCHAR(128) = 'MyDatabase';

DECLARE @nSQL NVARCHAR(MAX);

BEGIN

SET @nSQL = '

IF NOT EXISTS (SELECT *...

morepainot (8/8/2012)

---

Sean Lange (8/8/2012)

---

morepainot (8/8/2012)

---

Sean Lange (8/8/2012)

---

Because you already a print command in your code. In the snippet I provided I replace the exec with print because executing your dynamic...

BEGIN

SET @nSQL= '

IF NOT EXISTS ( SELECT * FROM '+ @SourceDatabaseName + ' .INFORMATION_SCHEMA.COLUMNS ...

Sean Lange (8/8/2012)

---

morepainot (8/8/2012)

---

Sean Lange (8/8/2012)

---

Because you already a print command in your code. In the snippet I provided I replace the exec with print because executing your dynamic code...

Sean Lange (8/8/2012)

---

Because you already a print command in your code. In the snippet I provided I replace the exec with print because executing your dynamic code is what was...

Sean Lange (8/8/2012)

---

morepainot (8/8/2012)

---

Sean Lange (8/8/2012)

---

morepainot (8/8/2012)

---

Sean Lange (8/8/2012)

---

morepainot (8/8/2012)

---

Sean Lange (8/8/2012)

---

morepainot (8/8/2012)

---

I have a print command at ever end. When I test the code its kicking back to this...

Lynn Pettis (8/8/2012)

---

Can't really answer your question about double processing, can't see what you see. Also, we don't have your tables or sample data so we can't run your...

morepainot (8/8/2012)

---

Sean Lange (8/8/2012)

---

morepainot (8/8/2012)

---

Sean Lange (8/8/2012)

---

morepainot (8/8/2012)

---

Sean Lange (8/8/2012)

---

morepainot (8/8/2012)

---

I have a print command at ever end. When I test the code its kicking back to this part of...

Sean Lange (8/8/2012)

---

Because you already a print command in your code. In the snippet I provided I replace the exec with print because executing your dynamic code is what was...

Sean Lange (8/8/2012)

---

morepainot (8/8/2012)

---

Sean Lange (8/8/2012)

---

morepainot (8/8/2012)

---

Sean Lange (8/8/2012)

---

morepainot (8/8/2012)

---

I have a print command at ever end. When I test the code its kicking back to this part of the...

Lynn Pettis (8/8/2012)

---

I know you did a lot of the work, but I have to ask you a question.

Do you feel comfortable enough with the code you have to describe...