Post reply

BCP - Executing Stored procedure throwing error

  • November 30, 2011 at 9:22 am

    #150683

    Hi,

    I have a stored procedure and i have used create tables inside the procedure. When i am trying to execute the procedure through BCP it is throwing error saying that table object not found. Can you please help.

    Thanks in Advance!!!

  • November 30, 2011 at 9:31 am

    #1414776

    Are you using the same login for testing the stored proc as that being used to execute the BCP command?

    The probability of survival is inversely proportional to the angle of arrival.

  • November 30, 2011 at 10:22 am

    #1414829

    yes. i am using the same login.

  • November 30, 2011 at 10:32 am

    #1414840

    can we see the bcp command?

    lets try to eliminate the simple things, like calling the proc without specifying the database.schema.procname, is it?

    could a copy of the proc exist in the MASTER database, so it fails because the assumed tables don't exist there?

    does the proc name start with sp_??

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • November 30, 2011 at 1:26 pm

    #1414908

    Hi,

    We are calling with DB.DBO.Procname. when we remove the create table script bcp runs fine.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply