Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tm
Posting Yak Master
160 Posts |
 Posted - 2013-12-10 : 13:23:14
|
| In our MSDB database, the table sysssislog is logging OnWarning messages and is creating a lot of entries into our sysssislog table.I have found this article regarding the logging level and it looks like the logging level is 1 but I cannot find how to set the logging level to 0.[url]http://technet.microsoft.com/en-us/library/bb677224(v=sql.105).aspx[/url]Looking into the sysssislog, I believe the log entries are from Microsoft Data Collector packages. I script out the Data Collection (SSMS>>Managment >>Data Collection>>System Data Collection Sets>>Disk Usage) and the script shows the logging level = 0. Also checked "Query Statistics" and "Server Activity".Would anyone know how to set the logging level to 0.Thanks in advance, |
|
|
|
|
|
sysssislog table - SSIS Logging Level Setting