posts - 218, comments - 410, trackbacks - 27

My Links

Advertisement

News

Follow billgraziano on Twitter

Article Categories

Archives

Post Categories

Consulting

SQL Server

Tuesday, October 09, 2012

SQL Server Configuration Scripting Utility Release 9

There’s another update to my little utility to script a SQL Server’s configuration.  I use this for two purposes.  First, I use it to keep my database mirroring servers up to date.  Second, I capture the output in a version control system and keep that for historical reference.

In release 3.0.9 I made the following changes:

  • Rewrote the encrypted trigger scripting.  It will now list the encrypted triggers in a comment in the table script but can’t actually script them.
  • It now scripts any server event notifications.
  • You can script a single database using the /scriptdb flag.  Please note that it will also script the instance and system databases when it does this.
  • It will script any user-defined endpoints.  This will capture your mirroring endpoints and more importantly any service broker endpoints.
  • It will gracefully skip database mail on the Express Edition.

It still doesn’t support SQL Server 2012.  I think that’s the next feature to add though.

posted @ Tuesday, October 09, 2012 5:59 PM | Feedback (0) | Filed Under [ Utilities ]

Powered by:
Powered By Subtext Powered By ASP.NET