locked
MBSA output for Sql Server 2005 Express RRS feed

  • Question

  • When I run MBSA 2,2 on a 2005 Express instance one of the results is:

     

    Sysdtslog: Do not create sysdtslogs90 in the Master or MSDB database. It is recommended to create a separate logging database.   (best practice)

     

    I am not using SSIS which is using this table so what is supposed to be done about this recommendation? Thks

    Monday, February 28, 2011 7:19 AM

All replies

  • Hi,

    From the error message, you may have 'Sysdtslog' table (used for SSIS package logging) in the Master or MSDB system database. Does this express instance upgraded from a previous version? Could you please double check that in master/msdb system database?


    Best Regards,
    Chunsong Feng

    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Wednesday, March 2, 2011 6:10 AM
  •  

    Hi peterc945,

     

    This table "sysdtslog90" is created when running an SSIS package only if we configured logging to log to a SQL Server database for this package. If you are not using logging feature for SSIS package, then we could ignore it.

     

    However, if you will use logging to log to SQL Server for SSIS package in the future, just follow the suggestion given by this result, create a separate logging database for your packages rather than the system databases.

     

    To specify a separate logging database, we could specify the database by choose a connection during the configuration of the Logging for SSIS package, and when running the package, this table sysdtslog90 will be created automatic to the specified database and log entries will be write to this table.

     

    Thanks,
    Weilin Qiao


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
    Wednesday, March 2, 2011 7:28 AM