Post reply

sysdtssteplog

  • September 28, 2005 at 10:07 am

    #91441

    Hi

    Is it OK to delete records from the sysdtssteplog and sysdtspackagelog tables? I'm thinking of deleting records for packages that ran x days ago.

    Are there any other dts related tables that I should include in my tidy-up

    Thanks

    Andy

  • September 28, 2005 at 11:18 am

    #593765

    It's okay to delete from the tables.  There are even stored procedures in MSDB that will do it - sp_dump_dtspackagelog and sp_dump_dtssteplog, though your idea of keeping them for x days will require checking the logdate column. 

    Microsoft is locking down system tables in SQL 2005, so these might not be available for updating in that release.  Come to think of it, they might not even exist with these names since DTS will become SSIS.

    Greg

    Greg

  • September 30, 2005 at 7:33 am

    #594322

    Thanks Greg

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply