SQL Syntax - Query Multiple Instances

[Smeat]

I have a stored procedure running on sql server A that needs to pull data from sql server B.

Sql server B has been linked to sql server A.

What is the syntax to query sql server B when sql server B has an instance name specified?

I.e. SELECT field1, field2 FROM ServerName\InstanceName.DatabaseName.dbo.TableName

This query won't run as it doesn't like the "\" character.

TIA
Smeat

 

[bborissov]

SELECT field1, field2 
       FROM [LinkedServerName].[DatabaseName].[dbo].[TableName]

Where "LinkedServerName" is the name of the linked server created on Server A.

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.