Cast Memo Varchar TSql 2008R2

Ex:
SELECT CAST(XMLRET AS VARCHAR(8000)), XMLRET FROM SPED400

ANTES:
0x3C6576656E746F2049643D22494431353331313337393130303030303032303137313232303139303231373235333832223E3C7265746F726E6F4576656E746F3E3C65536F6369616C20786D6C6E733D22687474703A2F2F7777772E65736F6369616C2E676F762E62722F736368656D612F6576742F7265746F726E6F4576656E746F2F76315F325F30223E3C7265746F726E6F4576656E746F2049643D22494431353331313337393130303030303032303137313232303139303231373235333832223E3C696465456D7072656761646F723E3C7470496E73633E313C2F7470496E73633E3C6E72496E73633E35333131333739313C2F6E72496E73633E3C2F696465456D7072656761646F723E3C726563657063616F3E3C7470416D623E323C2F7470416D623E3C6468526563657063616F3E323031372D31322D32305431393A30333A30332E3437373C2F6468526563657063616F3E3C76657273616F417070526563657063616F3E302E312E302D41303234393C2F76657273616F417070526563657063616F3E3C70726F746F636F6C6F456E76696F4C6F74653E312E322E3230313731322E303030303030303030303030303030313634303C2F70726F746F636F6C6F456E76696F4C6F74653E3C2F726563657063616F3E3C70726F63657373616D656E746F3E3C6364526573706F7374613E3430313C2F6364526573706F7374613E3C64657363526573706F7374613E436F6E746575646F20646F206576656E746F20696E76E16C69646F2E3C2F64657363526573706F7374613E3C76657273616F41707050726F63657373616D656E746F3E372E302E302D41323531343C2F76657273616F41707050726F63657373616D656E746F3E3C646850726F63657373616D656E746F3E323031372D31322D32305431393A30333A30332E353C2F646850726F63657373616D656E746F3E3C6F636F7272656E636961733E3C6F636F7272656E6369613E3C7469706F3E313C2F7469706F3E3C636F6469676F3E3133303C2F636F6469676F3E3C64657363726963616F3EC9206E6563657373E172696F206578697374697220696E666F726D61E7E36F2063616461737472616C20646F20656D7072656761646F722070617261206F20706572ED6F646F2E0A41E7E36F2053756765726964613A566572696669636172207365206AE120666F6920656E766961646F20756D206576656E746F2064652063616461737472616D656E746F20646F20656D7072656761646F722E3C2F64657363726963616F3E3C6C6F63616C697A6163616F3E3C2F6C6F63616C697A6163616F3E3C2F6F636F7272656E6369613E3C6F636F7272656E6369613E3C7469706F3E313C2F7469706F3E3C636F6469676F3E3932373C2F636F6469676F3E3C64657363726963616F3E4576656E746F206EE36F20E92061636569746F2070617261206F20656D7072656761646F722E0A41E7E36F2053756765726964613A20566572696669717565207365206F206576656E746F20E920636F6D706174ED76656C20636F6D206120636C6173736966696361E7E36F20747269627574E172696120646F20656D7072656761646F722E3C2F64657363726963616F3E3C6C6F63616C697A6163616F3E3C2F6C6F63616C697A6163616F3E3C2F6F636F7272656E6369613E3C2F6F636F7272656E636961733E3C2F70726F63657373616D656E746F3E3C2F7265746F726E6F4576656E746F3E3C2F65536F6369616C3E3C2F7265746F726E6F4576656E746F3E3C2F6576656E746F3E00

DEPOIS:

<?xml version="1.0" encoding="UTF-8"?>
<evento Id="ID1531137910000002017122019021725382">
   <retornoEvento>
      <eSocial xmlns="http://www.esocial.gov.br/schema/evt/retornoEvento/v1_2_0">
         <retornoEvento Id="ID1531137910000002017122019021725382">
            <ideEmpregador>
               <tpInsc>1</tpInsc>
               <nrInsc>53113791</nrInsc>
            </ideEmpregador>
            <recepcao>
               <tpAmb>2</tpAmb>
               <dhRecepcao>2017-12-20T19:03:03.477</dhRecepcao>
               <versaoAppRecepcao>0.1.0-A0249</versaoAppRecepcao>
               <protocoloEnvioLote>1.2.201712.0000000000000001640</protocoloEnvioLote>
            </recepcao>
            <processamento>
               <cdResposta>401</cdResposta>
               <descResposta>Conteudo do evento inválido.</descResposta>
               <versaoAppProcessamento>7.0.0-A2514</versaoAppProcessamento>
               <dhProcessamento>2017-12-20T19:03:03.5</dhProcessamento>
               <ocorrencias>
                  <ocorrencia>
                     <tipo>1</tipo>
                     <codigo>130</codigo>
                     <descricao>É necessário existir informação cadastral do empregador para o período. Ação Sugerida:Verificar se já foi enviado um evento de cadastramento do empregador.</descricao>
                     <localizacao />
                  </ocorrencia>
                  <ocorrencia>
                     <tipo>1</tipo>
                     <codigo>927</codigo>
                     <descricao>Evento não é aceito para o empregador. Ação Sugerida: Verifique se o evento é compatível com a classificação tributária do empregador.</descricao>
                     <localizacao />
                  </ocorrencia>
               </ocorrencias>
            </processamento>
         </retornoEvento>
      </eSocial>
   </retornoEvento>
</evento>

Shrinkfile SqlServer2008R2

Exemplo:

ALTER DATABASE WR_TF2 
SET RECOVERY SIMPLE;  
GO  
-- Shrink the truncated log file to 1 MB.  
DBCC SHRINKFILE (WR_TF2_log, 1) ;  
GO  
-- Reset the database recovery model.  
ALTER DATABASE WR_TF2
SET RECOVERY FULL;  
GO