title: Run a script before UnitTesting
body: <p>The Test Initialize script in the SQL Server Unit Tests runs before each test methods
  and Test Clean up runs after each test methods.</p>
  
  <p>So for example I have this structure</p>
  
  <pre><code>UnitTests          -- Main Project
    - FooSchema      -- Test Class
       - SprocFoo1   -- Individual Unit Tests / Test Methods 
       - SprocFoo2
    - BarSchema
       - SprocBar1
       - SprocBar2
  </code></pre>
  
  <p>The Test Run like this</p>
  
  <pre><code> -- Test Initialiaze for TestClass FooSchema
      -- Pre-Test   -- for SprocFoo1
      -- Test       -- for SprocFoo1
      -- Post-Test  -- for SprocFoo1
      -- Pre-Test   -- for SprocFoo2
      -- Test       -- for SprocFoo2
      -- Post-Test  -- for SprocFoo2
   -- Test Cleanup for TestClass FooSchema
   -- Test Initialiaze for TestClass BarSchema
      -- Pre-Test   -- for SprocBar1
      -- Test       -- for SprocBar1
      -- Post-Test  -- for SprocBar1
      -- Pre-Test   -- for SprocBar2
      -- Test       -- for SprocBar2
      -- Post-Test  -- for SprocBar2
   -- Test Cleanup for TestClass BarSchema
  </code></pre>
  
  <p>How could I add a script that would run in the very beggining of the project and also a script that will run at the very end of the project? </p>
  
  <p>So it would run like this</p>
  
  <pre><code> -- Pre MasterUnitTest
   -- Test Initialiaze for TestClass FooSchema
      -- Pre-Test   -- for SprocFoo1
      -- Test       -- for SprocFoo1
      -- Post-Test  -- for SprocFoo1
      -- Pre-Test   -- for SprocFoo2
      -- Test       -- for SprocFoo2
      -- Post-Test  -- for SprocFoo2
   -- Test Cleanup for TestClass FooSchema
   -- Test Initialiaze for TestClass BarSchema
      -- Pre-Test   -- for SprocBar1
      -- Test       -- for SprocBar1
      -- Post-Test  -- for SprocBar1
      -- Pre-Test   -- for SprocBar2
      -- Test       -- for SprocBar2
      -- Post-Test  -- for SprocBar2
   -- Test Cleanup for TestClass BarSchema
   -- Post MasterUnitTest
  </code></pre>