Sitecore Log4net

z.Logging.config

<?xml version="1.0" encoding="UTF-8"?>
<configuration xmlns:patch="http://www.sitecore.net/xmlconfig/">
   <sitecore>
      <log4net>
         <appender name="ADONetAppender_SqlServer" type="log4net.Appender.ADONetAppender, Sitecore.Logging">
            <bufferSize value="1" />
            <param name="ConnectionType" value="System.Data.SqlClient.SqlConnection, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
            <param name="ConnectionString" value="user id=[userName];password=[password];Data Source=[ServerName];Database=Sitecore.Logging" />
            <param name="CommandText" value="INSERT INTO Log ([Date],[Thread],[Level],[Logger],[Message]) VALUES (@log_date, @thread, @log_level, @logger, @message)" />
            <param name="Parameter">
               <param name="ParameterName" value="@log_date" />
               <param name="DbType" value="DateTime" />
               <param name="Layout" type="log4net.Layout.PatternLayout">
                  <param name="ConversionPattern" value="%d{yyyy'-'MM'-'dd HH':'mm':'ss'.'fff}" />
               </param>
            </param>
            <param name="Parameter">
               <param name="ParameterName" value="@thread" />
               <param name="DbType" value="String" />
               <param name="Size" value="255" />
               <param name="Layout" type="log4net.Layout.PatternLayout">
                  <param name="ConversionPattern" value="%t" />
               </param>
            </param>
            <param name="Parameter">
               <param name="ParameterName" value="@log_level" />
               <param name="DbType" value="String" />
               <param name="Size" value="50" />
               <param name="Layout" type="log4net.Layout.PatternLayout">
                  <param name="ConversionPattern" value="%p" />
               </param>
            </param>
            <param name="Parameter">
               <param name="ParameterName" value="@logger" />
               <param name="DbType" value="String" />
               <param name="Size" value="255" />
               <param name="Layout" type="log4net.Layout.PatternLayout">
                  <param name="ConversionPattern" value="%c" />
               </param>
            </param>
            <param name="Parameter">
               <param name="ParameterName" value="@message" />
               <param name="DbType" value="String" />
               <param name="Size" value="4000" />
               <param name="Layout" type="log4net.Layout.PatternLayout">
                  <param name="ConversionPattern" value="%m" />
               </param>
            </param>
         </appender>
         <root>
            <priority value="INFO" />
            <appender-ref ref="LogFileAppender">
               <patch:attribute name="ref">ADONetAppender_SqlServer</patch:attribute>
            </appender-ref>
         </root>
         <logger name="Sitecore.Diagnostics.WebDAV" additivity="false">
            <level value="INFO" />
            <appender-ref ref="WebDAVLogFileAppender">
               <patch:attribute name="ref">ADONetAppender_SqlServer</patch:attribute>
            </appender-ref>
         </logger>
         <logger name="Sitecore.Diagnostics.Publishing" additivity="false">
            <level value="INFO" />
            <appender-ref ref="PublishingLogFileAppender">
               <patch:attribute name="ref">ADONetAppender_SqlServer</patch:attribute>
            </appender-ref>
         </logger>
         <logger name="Sitecore.Diagnostics.Crawling" additivity="false">
            <level value="INFO" />
            <encoding value="utf-8" />
            <appender-ref ref="CrawlingLogFileAppender">
               <patch:attribute name="ref">ADONetAppender_SqlServer</patch:attribute>
            </appender-ref>
         </logger>
         <logger name="Sitecore.Diagnostics.Search" additivity="false">
            <level value="INFO" />
            <encoding value="utf-8" />
            <appender-ref ref="SearchLogFileAppender">
               <patch:attribute name="ref">ADONetAppender_SqlServer</patch:attribute>
            </appender-ref>
         </logger>
      </log4net>
   </sitecore>
</configuration>