Add sp procedure to the master for running the Unit Tests


We have created an sp procedure (sp_utf_run - which is according to our naming convention) that is deployed on the master database. This allows us to run the unit tests more easily.
We assign a SSMS keyboard shortcut to this procedure (e.g. Ctrl-9).
When we are in a query window and
  • have no text selected, pressing Ctrl-9 will launch RunAll for the current database
  • have a unit test selected (starting with the correct prefix), pressing Ctrl-9 will launch RunTest for the specific test
  • have a suite name selected, pressing Ctrl-9 will launch RunSuite for the specific suite
    This means we no longer have to type TST.Runner.RunXYZ ... to run the unit test.
    Maybe this feature can be included in the project. Code added.
    Defaults for verbose and format can be changed in the procedure template. We opted for verbose on and format Text.
    Maybe the proc needs to be changed if schema's are used. We always deploy under dbo.

file attachments


lmolnar wrote Apr 1, 2012 at 3:02 AM

Nice idea but I will have to postpone this until a next version..

wrote Feb 14, 2013 at 2:57 AM