Before my hard disk failed , I had backup MSSQL7 folder.After I re format it and attached the database [MDF ,LDF ] I lost my stored procedures.Can someone help me or show me how to recover my stored procedures.
The SPs are part of the database and should be there if the database is not corrupt.
Maybe they are owned by a different user or mapped to a different login.
Try select * from sysobjects where type = 'P'
and look in syscomments
select text from syscomments where text like '%myspname%'