[CR# 290014] Migration tool does not handle temporary tables that are referenced within a stored procedure but expected to exist prior to sproc executing
2002/07/16 17:28:02.818\TASK (1:11)\ERROR\ Error while executing SQL for migration of 'P.dbo...rsm_where_list;1' Root Cause;Msg 208, Level 16, State 1 Server DST, Procedure rsm_where_list, Line 52, Status 0, TranState 1 #subs not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output). Msg 208, Level 16, State 1 Server DST, Procedure rsm_where_list, Line 67, Status 0, TranState 1 #rules not found. Specify owner.objectname or use sp_help to check whether object exists (sp_help may produce lots of output). Msg 208, Level 16, State 1 Server DST, Procedure rsm_where_list, Line 70, Status 0, TranState 1 #rules not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
Workaround: User must manually create this store procedure after the migration.