title: Altering a table on a different server through a query
body: <p>I'm writing some dynamic SQL (I'm fairly new to it) and am trying to automate the altering of multiple tables which may exist on different instances of SQL Server 2008.  My servers are linked and I know which server each of the tables exists on, however when I try to run the query below, I get "Cannot find object...because it does not exist or you do not have persmissions"</p>
  
  <p>Query: </p>
  
  <pre><code>Alter Table [Server10].[Database2].[dbo].[documents] Add NewField int
  </code></pre>
  
  <p>If I connect to the server in SSMS and drop the server name (Server10) it works. </p>
  
  <p>Any suggests on how to create this query.  Thanks</p>