• David Webb-200187 (3/22/2013)


    Just for ease of use and potentially quicker response, I tend to script out things like logins, database users, procs, triggers, and views that I might need to restore quickly. If the objects are kept in a source control system somewhere, this become less critical for the non-login related stuff. But not all of my clients lock production down appropriately, so sometimes they 'accidentally lose' important things that are needed back very quickly.

    Would you be willing to share your scripts? Or are you talking about creating them by right clicking, script out, create to, new query editor window from MSSMS?