In Adaptive Server version 11.5 and in SQL Server® versions earlier than that release, the source text was saved in syscomments so it could be returned to a user who executed sp_helptext. Because this was the only purpose of saving the text, users often deleted the source text from the syscomments table to save disk space and to remove confidential information from this public area. However, deleting the source text may cause a problem for future upgrades of Adaptive Server.
If a compiled object does not have matching source text in the syscomments table, you can restore the source text to syscomments using any of the following methods:
Load the source text from a backup.
Re-create the source text manually.
Reinstall the application that created the compiled object.
