[ Back to Sprockit home page ]

Get Sprockit

Download the latest version of Sprockit here!

  • SQL Server 2008 R2 or later (SQL 2012 if you want to schedule SSIS packages from the catalog)
  • SQL Server Agent
  1. Create a new database on your SQL Server.
  2. Download the Sprockit install script.
  3. Open the downloaded script file in SSMS, connect to your Sprockit database, then run it.
  4. Schedule the new 'Run Sprockit…' agent job as required. (This is Sprockit's process manager).
  1. :!: Backup your existing Sprockit database!
  2. Download the Sprockit install script.
  3. Open the downloaded script file in SSMS, connect to your Sprockit database, then run it.

Upgrading from a prior version uses the same script as a brand new install.

The current version of Sprockit is v1.5.4.

Follow me on Twitter for notification of new releases!

  • Release of sprockitviz for interactive ETL pipeline visualisation.
  • Delay removal of process reservations after successful completion until start of next batch (release on completion may allow process re-execution of very short duration processes on severely under-resourced SQL instances).
  • Added sprockit.uvw_Process.[IsStoredQuery]
  • Removed bootstrap job (process manager now scheduled directly, restarted at step 2)
  • Bug in circular dependency detection (trg_DetectCircularDependency) fixed
  • usp_ConfigureProcess fixed to report error with poorly-formatted resources (rather than failing silently)
  • Property install fixed to prevent existing configuration from being overwritten