Re: Biztalk MessageBox SQL Server logs



Hi Joost,

You will need to enable the TrackingSpool_Cleanup_BizTalkMsgBoxDb job
on the SQL Server where the BizTalk databases (MsgBox) reside. It is
not enabled by default and it will clean-up the tracking spool tables.

Thanks,

Marian Drumea [MVP]
http://www.MarianDrumea.com

.



Relevant Pages

  • How can I trap an error on a "CommitTrans" command in VB6 using ADO and SQL Server 2000?
    ... I have a VB6 executable that uses SQL Server 2000 as it's database. ... On Error GoTo TransError ... MsgBox "About to commit transaction." ... How can I know if the CommitTrans statement failed? ...
    (microsoft.public.vb.database.ado)
  • Re: TSQL Trap for Timeout Expired
    ... >I'd like to be able to trap the error and do either a msgbox or on error resume ... Have a look at the VBScript reference available online - ... DTS - http://www.sqldts.com PASS - the definitive, global community for SQL Server professionals ...
    (microsoft.public.sqlserver.dts)
  • Re: Getting File Info using GetDetailsOf
    ... files that reside in c:\temp folder. ... Set objShell = CreateObject ... MsgBox i & vbtab & arrHeaders_ ...
    (microsoft.public.scripting.vbscript)
  • How do I convert datasets?
    ... The business logic needs to reside in a COM+ middle tier. ... for SQL Server: ...
    (borland.public.delphi.database.ado)
  • Re: Getting File Info using GetDetailsOf
    ... files that reside in c:\temp folder. ... Set objShell = CreateObject ... MsgBox i & vbtab & arrHeaders_ ...
    (microsoft.public.scripting.vbscript)