Try to restore the databese with SP's from backup under different name.
>I really want to cry and don't know how to do now.
>Origianll, I choose all SP and generate a SQL script , I copy the script
>into SQL Analzyer , and run it
>I press 'stop' carelessly, then I found all the SP are dropped already.
>
>Then I am so stupid that close the SQL analzyer, and reopen it.
>NOW, I LOST everything, I check that there is a log in
>G:\Program Files\Microsoft SQL Server\MSSQL\Data\myDataBase_Log
>
>is That I can use it recover it ????????
>Please help ~~~~
--sb--