The document is archived and information here might be outdated
Failed to load source for stored procedure.
A failure occurred while loading the source for a stored procedure. The stored procedure cannot be loaded into the editor. This is probably caused by a damaged file. You can try the following remedial actions:
Recreate the stored procedure by regenerating or recovering a previous version from source control.
Restart Visual Studio and try again.