Need help on Linked Server - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Need help on Linked Server

Author

Topic

wkm1925
Posting Yak Master

207 Posts

Posted - 2010-11-25 : 01:43:11

My database server as follow,
1. mfc-wms (SQL Server 2005 SE 32 bit)
2. mfc-svr1 (SQL Server 2008 EE 64 bit)

In mfc-svr1 contains instanse as follow
1. nav1 (mfc-svr1\nav1)
database as follow
1. ST3DB
and table as follow
1. dbo.tTrans

So far, i've successfull setup the Linked Server (mfc-svr1) in mfc-wms. Huhu..

Unfortunately, my simple SQL statement as follow

SELECT * FROM mfc-svr1\nav1.ST3DB.dbo.tTrans

return error as Incorrect syntax near '-'.

wkm1925
Posting Yak Master

207 Posts

Posted - 2010-11-25 : 01:46:17

It solved.

SELECT * FROM [mfc-svr1\nav1].ST3DB.dbo.tTrans

Horey

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources