Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2001
    Posts
    46

    Unanswered: Recover stored procedures

    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.

    Thanks.

  2. #2
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    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%'

  3. #3
    Join Date
    Sep 2001
    Posts
    46
    Thanks for your fast response , I am so lucky that get back my 150 stored procedures back from my old 500 MB hard disk !!!

    Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •