Why am I getting an invalid object name error here for CustomColumns?

SET @nsql = '

SELECT

ColumnName + ''Column is missing from the Table' + 'TableName'+' of '+@StageDatabaseName+'...

Lynn Pettis (8/1/2012)

---

Looking really good. You are on the right track for what you need to accomplish. I like the code you are writing, it is well structured,...

Lynn Pettis (8/1/2012)

---

Also, this code is not what you should necessarily use directly. It should probably be extended and expanded to make use of your logging tables, etc. ...

Sean Lange (8/1/2012)

---

morepainot (8/1/2012)

---

Oh man looks like Im going to have trouble with this review tomorrow. I have a developer who is remotely looking at ny code but hes the...

Sean Lange (8/1/2012)

---

•Do all staged tables exist in the source and in the stage database?

•Do all staged columns exist in the source and in the stage database?

•Is the data type...

Oh man looks like Im going to have trouble with this review tomorrow. I have a developer who is remotely looking at ny code but hes the type the guy...

morepainot (8/1/2012)

---

Lynn Pettis (8/1/2012)

---

morepainot (8/1/2012)

---

Okay, understood. This code is really long but Im going to post it with all the errors, mostly fixed. This included the procs usp_PreStageValidation and usp_PostStageValidation

ALTER...

Lynn Pettis (8/1/2012)

---

morepainot (8/1/2012)

---

Okay, understood. This code is really long but Im going to post it with all the errors, mostly fixed. This included the procs usp_PreStageValidation and usp_PostStageValidation

ALTER PROCEDURE...

Sean Lange (8/1/2012)

---

You need step...

Okay, understood. This code is really long but Im going to post it with all the errors, mostly fixed. This included the procs usp_PreStageValidation and usp_PostStageValidation

ALTER PROCEDURE usp_PreStageValidation @ApplicationName VARCHAR(100)

,@SQL_str1...

Sean Lange (8/1/2012)

---

morepainot (8/1/2012)

---

Should I do the same for this? I used your suggestion for the procedure and looks like the problem was solved. I have ONE more after this...

Should I do the same for this? I used your suggestion for the procedure and looks like the problem was solved. I have ONE more after this and I promise...

[/color]

No, it means the procedure alread exists and you are trying to create it again. Two things you can do. One, change the CREATE PROCEDURE to ALTER PROCEDURE....

Ok, I took care of those errors. Now the only errors I am getting are

"Msg 2714, Level 16, State 3, Procedure usp_PreStageValidation, Line 185

There is already an object named...

I add GO before every proc? Its giving me an incorrect syntax error right about it where the comment lines are.

GO

CREATE PROCEDURE syd_StagedCols_DT_Differ_SourceCols

@ApplicationName VARCHAR(100)

,@SourceDatabaseName VARCHAR(100)

,@SQL_str NVARCHAR(max) OUT AS

SET...