Can't open sproc from SSMS

Added: 6/29/2017 8:00 PM

---

When you try to Modify an existing stored procedure in Microsoft SQL Server Management Studio, you may get the error Syntax error in TextHeader of StoredProcedure, and it will not allow you to view the sproc. You may think the sproc is lost forever, but there is an easy workaround to get access to its code again: Replace xxxxxxxxxxxxx with your sproc name: sp_helptext N'xxxxxxxxxxxxx' When you run that command, it will give you the sproc text. From there, you can hopefully fix the script and update it to fix the error.