title: Create View using Linked Server db in SQL Server
body: <p>How can I create View on Linked Server db. For Example I have a linked server [1.2.3.4] on [5.6.7.8]. Both db servers are SQL Sserver 2005. I want to create View on [5.6.7.8] using table on linked server.</p>
  
  <p><strong>EDIT:</strong></p>
  
  <p>On creating using full name, [1.2.3.4].db.dbo.table, I am getting this error.</p>
  
  <p>SQL Execution Error.</p>
  
  <p>Executed SQL statement: SELECT * FROM  1.2.3.4.db.dbo.table <strong><em>(YOu can see brackets are not there.)</em></strong>
  Error Source: .Net SqlClient Data Provider
  Error Message: Incorrect syntax near '0.0'. ---> part of IP address.</p>
  
  <p>I am just creating this in ManagementStudio, not using it because it is not created yet. I Have changed IP. In image you can see there are not brackets around IP but I given it and on error these brackets are removed.</p>
  
  <p>Thanks.</p>