Linked Server Select 1

[DrSql]

I am creating a select statement from Server db to Server B db. The Server B instance is called ServerB\VS2
The links are fine.

select * from ServerB\VS2.dbo.tablename
error:Server: Msg 170, Level 15, State 1, Line 6
Line 6: Incorrect syntax near '\'.


Any suggestions?


Dr.Sql
Good Luck.

 

[mrdenny]

Brackets. You also need to use the full four part name, not a three part name.

select *
from [ServerB\VS2].DatabaseName.dbo.tablename

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[DrSql]

Thanks for the qucik response..

Dr.Sql
Good Luck.

 

[mrdenny]

no problem.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)