title: SQL Server insert trigger not working
body: <p>This is my first time using triggers.</p>
  
  <p>My trigger is not being triggered please help.</p>
  
  <pre><code>CREATE TRIGGER sbhack_autoban
  ON LOG_CONNECT201211
  FOR INSERT
  AS
    BEGIN
        /* query to run if single or multiple data is 
         inserted into LOG_CONNECT201211 table */
        UPDATE login.dbo.USER_CHECK_LOGIN
        SET    login.dbo.USER_CHECK_LOGIN.CHECKLOGIN = 2
        WHERE  login.dbo.USER_CHECK_LOGIN.USER_KEY IN 
                (SELECT e.USER_KEY
                   FROM   game.dbo.CHAR_DATA0 AS e
                          INNER JOIN gamelogs.dbo.LOG_USING_DEPOT201211 AS p
                            ON e.CHAR_KEY = p.CHAR_KEY
                   WHERE  p.GATENUM = 150)
               AND login.dbo.USER_CHECK_LOGIN.CHECKLOGIN = 0
               AND login.dbo.USER_CHECK_LOGIN.USER_KEY != 51;
    END 
  </code></pre>
  
  <p>This is suppose to run the query inside the BEGIN : END if an entry is inserted into the <code>LOG_CONNECT201211</code> table. But nothing is happening even when I have inserted multiple data into <code>LOG_CONNECT201211</code>.</p>