• I'm sorry to resurrect this guy from the dead, but I'm curious as to what the conventional wisdom is for the SCPTXFR tool for sql 2008?

    I know I can right click in SSMS and generate scripts for the entire database. What if I want to regularly create and back up those scripts?