I get the following error when i call a procedure with in a procedure. Not only that, this error is intermittent i.e. i get error sometimes and sometimes the job executes just fine. Message 207, Level 16, State 1 Invalid column name I know for sure that there is no invalid column name anywhere in the body of the stored procedure. When i get the error and i execute the procedure directly(thats called by another procedure), it executes just fine. I have notbeen unable to trouble shoot this error. Bigger problem is that it doesnt error out all the times, only half the time. Thanks, PS