Question5: The Fastest Way to Recompile All Stored Procedures I have a problem with a dat

Question5: The Fastest Way to Recompile All Stored Procedures

I have a problem with a database running in SQL Server 6.5 (Service Pack

4). We moved the database (object transfer) from one machine to another last

night, and an error (specific to a stored procedure) is cropping up. However, I

can't tell which procedure is causing it. Permissions are granted in all of our

stored procedures; is there a way from the isql utility to force all stored

procedures to recompile？

Tips: sp_recompile can recomplie a store procedure each time