Deleting logs

Tech-Archive recommends: Fix windows errors by optimizing your registry



I have designed a DTS package and have enabled SQL Server logging in
the properties of the DTS package. Since this is writing to the msdb,
does it just keep on writing? How do I specify how long I want to keep
the logging information around in the msdb?

Thanks,
Kayda

.



Relevant Pages

  • Re: Where in msdb can I find Active X Scripts from a DTS package
    ... DTS Package data is stored in a system table in msdb, called sysdtspackages, ... How to Upgrade to SQL Server 2000 Retail Version After SQL Server 2000 ... I am trying to recover a DTS package containing an ACtive X Script after my ...
    (microsoft.public.sqlserver.programming)
  • Restore a DTS Packaga Saved As Visual Basic File?
    ... SQL Server 2000 DTS package deleted from MSDB. ... DTS package previously saved as a Visual Basic file. ... Is there a way to restore the DTS package to the SQL Server MSDB using only the Visual Basic file? ...
    (microsoft.public.sqlserver.dts)
  • Re: recovery of dts packages
    ... Was your colleague saving the dts package to SQL Server? ... data can be found in the sysdtspackages table of msdb database. ...
    (microsoft.public.sqlserver.dts)
  • Re: exception error when closing app
    ... Yes, bulk insert. ... data from an external data source and writing ... through my DTS package in the vb.net app. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Restore a DTS Packaga Saved As Visual Basic File?
    ... Open the VB module file in VB and add a reference to the DTS Package Object ... No MSDB backkup. ... Is there a way to restore the DTS package to the SQL Server MSDB using only the Visual Basic file? ...
    (microsoft.public.sqlserver.dts)