title: Trigger to run stored procedure SQL Server 2008
body: <p>I have staging table for data, every month company insert data in staging table. I am using a stored procedure to copy data form staging to multiple tables. I want to create a trigger to run these stored procedures. </p>
  
  <p>For example my staging table <code>blk_data</code> and my stored procedure is  <code>sp_payment</code>, I tried to using something like </p>
  
  <pre><code>IF EXISTS (SELECT name FROM sysobjects
             WHERE name = 'trg_pay' AND type = 'TR')
     DROP TRIGGER blk_data
  GO
  
  CREATE TRIGGER trg_pay
  ON payroll
  FOR INSERT, UPDATE, DELETE
  AS
     sp_payment
  GO
  </code></pre>
  
  <p>but it doesn't work. Please correct me. </p>
  
  <p>Thanks!</p>