Post reply

Invalid Object Name

  • August 18, 2003 at 7:49 am

    #106058

    In my store procedure, I am creating several temporary tables. Query runs fine in Analyzer, but in DTS I am getting an error message "Invalid Object Name #temptable. Any suggestions? I am using SQL2000.

    Thanks!

  • August 19, 2003 at 12:59 pm

    #470458

    Remember that temp tables are only local to the current connection. You DTS could be opening more than one connection, or just can't access the temp table.

    Try creating global tables (##) instead of temp tables (#), or just creating a normal table, and erase it at the end of the sp.

  • August 19, 2003 at 8:30 pm

    #470517

    I have changed the temporary to global temp. tables and still getting the same error message.

  • August 20, 2003 at 5:17 am

    #470560

    Try creating a normal table in the database your connection for the sp is running. drop the table after use as mentioned above. this should work. You may want to leave the drop out to test the table is being created in the first place with the permission of the dts connection.

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

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