Viewing 15 posts - 31 through 45 (of 56 total)
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+'...
August 2, 2012 at 12:11 pm
Lynn Pettis (8/1/2012)
August 1, 2012 at 3:20 pm
Lynn Pettis (8/1/2012)
August 1, 2012 at 2:07 pm
Sean Lange (8/1/2012)
morepainot (8/1/2012)
August 1, 2012 at 12:39 pm
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...
August 1, 2012 at 12:36 pm
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...
August 1, 2012 at 12:33 pm
morepainot (8/1/2012)
Lynn Pettis (8/1/2012)
morepainot (8/1/2012)
ALTER...
August 1, 2012 at 12:27 pm
Lynn Pettis (8/1/2012)
morepainot (8/1/2012)
ALTER PROCEDURE...
August 1, 2012 at 12:19 pm
Sean Lange (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
You need step...
August 1, 2012 at 12:17 pm
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...
August 1, 2012 at 10:30 am
Sean Lange (8/1/2012)
morepainot (8/1/2012)
August 1, 2012 at 10:02 am
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...
August 1, 2012 at 9:59 am
[/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....
August 1, 2012 at 9:48 am
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...
August 1, 2012 at 9:11 am
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...
August 1, 2012 at 9:00 am
Viewing 15 posts - 31 through 45 (of 56 total)