Find stored procedures that won’t compile
Here’s a handy little code snippet. Find any stored procedures that won’t compile on SQL Server. The routine will list all procedures, showing ‘– Failed’ with the error messages for those that fail. Note that recompiling the procedures may also throw dependency errors also that can’t be caught with try/catch block … these errors likely… Read More Find stored procedures that won’t compile