DTS package version deletion

Hi,
Please let me know if there is any system stored procedure which can be used
to delete the older versions of dts packages in SQL Server 2000 as in my
environment due to heavy use of dts packages msdb grows beyond 5-7 GB and ea
t
up the disk space.
Any other user SP(if no system SP is thr) if provided will also do.
Thanks
Manu JaidkaHello Manu,
This may not be because of DTS packages, this shlould be definetely because
SQL Server stores all the backup and Restore history information
in MSDB Database. Take a look into below URL, which talks about all the
system tables stores history and the methodology to archive those tables
using
sp_delete_backuphistory (Transact-SQL) .
http://msdn2.microsoft.com/en-us/library/ms188653.aspx
Thanks
Hari
"manu" <manu@.discussions.microsoft.com> wrote in message
news:7B924DA7-08B3-4232-BDC5-722C6FA73D11@.microsoft.com...
> Hi,
> Please let me know if there is any system stored procedure which can be
> used
> to delete the older versions of dts packages in SQL Server 2000 as in my
> environment due to heavy use of dts packages msdb grows beyond 5-7 GB and
> eat
> up the disk space.
> Any other user SP(if no system SP is thr) if provided will also do.
> Thanks
> Manu Jaidka|||Hi Hari,
Actually I suspected the same at the first go but after using this
SP(sp_delete_backuphistory) and deleting records older than 2 months it free
d
up very little space in msdb database then I started looking at other side
and came to know that dts packages versions dated 2004 were still there in
msdb database.
After manual deletion of them and retaining only last two months version
history I managed to bring down msdb from 5 Gb to 200 MB.
I am in dire need of one SP which can do the same.
Thanks
Manu Jaidka
"Hari Prasad" wrote:

> Hello Manu,
> This may not be because of DTS packages, this shlould be definetely becaus
e
> SQL Server stores all the backup and Restore history information
> in MSDB Database. Take a look into below URL, which talks about all the
> system tables stores history and the methodology to archive those tables
> using
> sp_delete_backuphistory (Transact-SQL) .
> http://msdn2.microsoft.com/en-us/library/ms188653.aspx
> Thanks
> Hari
>
> "manu" <manu@.discussions.microsoft.com> wrote in message
> news:7B924DA7-08B3-4232-BDC5-722C6FA73D11@.microsoft.com...
>
>sqlsql