title: Bulk Insert from sqlcmd not firing trigger
body: <p>I'm using <code>sqlcmd</code> in a batch file to do weekly imports. </p>
  
  <pre><code>sqlcmd -U xxxx -P xxxx -i E:\data\importtc.sql
  </code></pre>
  
  <p>The command is executing, </p>
  
  <pre><code>bulk insert [xxxx].[dbo].[Stage] 
     from 'E:\Acct\timecards\timecard.txt' 
     with (fieldterminator = ',', rowterminator = '\n', FIRE_TRIGGERS)
  go
  </code></pre>
  
  <p>From inside the SQL Server Management Studio, this works fine. However when I exec it from <code>SQLCMD</code> it won't fire the trigger that manipulates some of the data. </p>
  
  <p>Anyone encountered this before? Thank you.</p>