I have a stored procedure that creates a tempdb..table with in the stored procedure. First it checks whether the temporary table exists and if exists it drops the table first and then re/creates it. I can successfully run this procedure from isql, sql advantage and dbartizan clients. But when it is run from informatica it gives me the error temporary table not found. After executing from informatica, if I execute it from isql or any other clients it gives me the same error. If I drop and recreate the store procedure it again runs fine on isql and other clients the story being same for informatica. Is there any constraint on informatica for such stored procedures which drop and recreate a temporary table?