How about scripting the stored procedures from the old database (Enterprise Manager -> Objects -> Generate SQL Scripts -> etc.), and then pull the script into Query Analyzer and select and run chunks of them (like 20 questions) until you narrow down the bad procedure?