title: sql server 2008 r2 "Cannot find the object because it does not exist or you do not have permissions"
body: <p>i want to execute sql command with server name. here is some example query</p>
  
  <pre><code> SELECT * FROM [SYSTEM1\SQLEXPRESS].Sample1.dbo.table1 
   INSERT INTO [SYSTEM1\SQLEXPRESS].Sample1.dbo.table1 values('BALA')
  </code></pre>
  
  <p>the above two executed successfully. in my table1 id filed is auto increment so 
  when i execute the following command it return the error message</p>
  
  <pre><code> SET IDENTITY_INSERT [SYSTEM1\SQLEXPRESS].Sample1.dbo.table1 ON
   INSERT INTO [SYSTEM1\SQLEXPRESS].Sample1.dbo.table1 values(2,'KARTHIK')
   SET IDENTITY_INSERT [SYSTEM1\SQLEXPRESS].Sample1.dbo.table1 OFF
  </code></pre>
  
  <p>Cannot find the object [SYSTEM1\SQLEXPRESS].Sample1.dbo.table1 because it does not exist or you do not have permissions. how to solve this problem</p>