Refering to SQL servers name having special characters
Posted by ohad on 09 Feb 2009 at 03:08 AM
$0.00
Hi there,
I would like to join 2 tables residing on different SQL Servers.
I know i am supposed refer to the tables using full path:
server.DB.owner.table
My problem is that my server names contain slashes and dashes (e.g. srv-1crm) and thus i get an "Incorrect syntax near '' "message.
How can i refer to a server having special characters?
Thanks,
Ohad.
I would like to join 2 tables residing on different SQL Servers.
I know i am supposed refer to the tables using full path:
server.DB.owner.table
My problem is that my server names contain slashes and dashes (e.g. srv-1crm) and thus i get an "Incorrect syntax near '' "message.
How can i refer to a server having special characters?
Thanks,
Ohad.
Accepted Answer:
| Answer provided by admin on 26 Sep 2008 at 05:22 AM Coco, you might take a look at Bob Drudge's excellent site at http://www.refdesk.com for ideas. Since most sites like that are copyrighted, I cannot advise you about the legalities of copying scripts. Might be best to email the authors requesting permission to do what you want to do. You leave yourself exposed by displaying copied things like that on your homepage. |
| Rating: * * * * * Awarded: $5.00 |
Ask a Question
Most Recent Questions
Most Recent Answers
Home Page
Login
Register
Information Technology
Programming Languages
Database
- Microsoft Access
- MySQL
- Oracle
- PostGreSQL
- SQL Server
- Visual FoxPro
Graphic Design
Operating Platforms
Hardware and Networking
Math and Science
Biology and Geology
Math and Statistics
Chemistry
Physics
Engineering

Are you an information
Most Recent Questions
Most Recent Answers
Home Page
Login
Register
Information Technology
Software, Hardware, Design
Programming LanguagesDatabase
- Microsoft Access
- MySQL
- Oracle
- PostGreSQL
- SQL Server
- Visual FoxPro
Graphic Design
Operating Platforms
Hardware and Networking
Math and Science
Homework Help
Biology and GeologyMath and Statistics
Chemistry
Physics
Engineering
Are you an information
technology or
math/science expert?
You can earn money by
providing answers to questions
at AnswerArchive.com.
Learn How