title: Adding insert into linked server inside a trigger
body: <p>I'm trying to run a trigger that allows me to insert the inserted data on my local table to the linked server's table. This is what I did:</p>
  
  <pre><code>use [medb]
  
  ALTER TRIGGER [dbo].[trigger1] ON [dbo].[tbl1]
  AFTER INSERT
  AS
  BEGIN
  
      INSERT into openquery(DEV, 'tbl_remotetbl') select * from inserted
          END
  </code></pre>
  
  <p>but it is giving this error:</p>
  
  <blockquote>
    <p>Cannot process the object "tbl_remotetbl". The OLE DB provider
    "MSDASQL" for linked server "DEV" indicates that either the object has
    no columns or the current user does not have permissions on that
    object.</p>
  </blockquote>
  
  <p>What seems to be my problem?
  Note: I am using SQL Server 2008 R2</p>