title: Bulk insert does not insert all the rows from the log file without giving any error
body: <p>i'm using the following code </p>
  
  <pre><code>create TABLE #temp1(                                          
   [date] [varchar](500) NULL,
   [time] [varchar](500) NULL,
   [s-ip] [varchar](500) NULL,
   [cs-method] [varchar](500) NULL,
   [cs-uri-stem] [varchar](max) NULL,
   [cs-uri-query] [varchar](max) NULL,
   [s-port] [varchar](500) NULL,
   [cs-username] [varchar](500) NULL,
   [c-ip] [varchar](500) NULL,
   [cs(User-Agent)] [varchar](2048) NULL,
   [cs(Referer)] [varchar](max) NULL,
   [sc-status] [varchar](max) NULL,
   [sc-substatus] [varchar](500) NULL,
   [sc-win32-status] [varchar](500) NULL,
   [time-taken] [varchar](500) NULL
   )
  
  BULK INSERT #temp1 FROM 'C:\iislogs\u_ex150108.log'
    WITH (
             FIRSTROW  = 5,
  
            FIELDTERMINATOR = ' ',
             ROWTERMINATOR = '\n',
             MAXERRORS = 10000
          )
  </code></pre>
  
  <p>and the file that, i'm using has 1521000 lines but i am getting only  1305226 in #temp1</p>
  
  <p>Please help
  Thanks in advance</p>