Another Update to SQL Server Configuration Scripting Utility

Posted by Bill Graziano on SQL Team See other posts from SQL Team or by Bill Graziano
Published on Tue, 10 Jul 2012 21:37:27 GMT Indexed on 2012/07/11 3:20 UTC
Read the original article Hit count: 180

Filed under:

I’ve been gradually adding features to my utility that scripts the configuration of a SQL Server.  Since my last post I’ve added the following features:

  • Skip any encrypted object in a database
  • Script alerts, alert notifications and operators
  • Script audits
  • Always script model, master and msdb to capture any user-defined objects in those databases
  • Logins are now scripted so that everything for a login is grouped together.
  • There’s a second section in the logins that handles default databases.  In many cases a login’s default database is a mirror target and can’t be set.  This is now handled gracefully.  It also includes a separate section for all default databases so those can be quickly set in the event of a disaster.
  • Script credentials
  • Script proxy accounts
  • Script database mail

My goal is still to get everything outside a database scripted.  This release is enough that I can keep my mirror target servers in sync with their principals.

© SQL Team or respective owner