title: TSQLT unit test - The data types text and text are incompatible in the equal to operator
body: <p>I am getting this error from AssertEqualsTable "The data types text and text are incompatible in the equal to operator."</p>
  
  <p>then</p>
  
  <p>"The 'TableCompare' procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead."</p>
  
  <pre><code>select   *
      into #Actual
      from [dbo].[InvoiceOut];
  
  --make expected table an empty table of #actual's structure because we truncate so it should be empty.
      SELECT TOP(0) *
      INTO #Expected
      FROM #Actual;
  
  EXEC tSQLt.AssertEqualsTable '#Expected', '#Actual';
  </code></pre>
  
  <p>--part of the relevant table info</p>
  
  <pre><code>CREATE TABLE [dbo].[InvoiceOut](
  ...
      [InsertField] [text] NULL,
      [DeductibleText] [text] NULL,
      [BarcodeText] [text] NULL
  ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  </code></pre>