title: Undo changes to SQL Server 2005 database
body: <p>I've ran some "ALTER" scripts on the database [SQL Server Server 2005], and overwrote some sprocs. Is there any way to undo changes and get my old sprocs back?</p>
  
  <p>Is there a way to get the scripts that were executed out of the .LDf file? That way i can re-run my initial "create" script for my sprocs.</p>
  
  <p>I don't have a backup file with old sprocs.</p>
  
  <p>p.s. i backed the DB up as per <a href="https://stackoverflow.com/users/4337/gulzar">@Gulzar's</a> deleted answer, and looks like I'm "hosed".</p>
  
  <p>@Pittsburgh DBA: thanx for the solution, but it doesn't seem to work after the backup.</p>
  
  <p><strong>MORAL: Wait for 10 minutes before trying the suggested answers out</strong></p>
  
  <hr>
  
  <p><strong>Update from Gulzar</strong>: What I meant was a file backup before trying anything (to be safe). Not a SQL Server backup.</p>