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.
| Author |
Topic |
|
bendertez
Yak Posting Veteran
94 Posts |
 Posted - 2010-01-29 : 09:46:32
|
| HelloI'm tring to connect to a database on another instance of SQL server through a link server connection.I've set up the connection without issue and can see and open all the tables etc.However, when I try query the data using an openquery statement i'm getting an error indicating that it doesn't like the name.The name is sql-server-v01, it looks like the ' - ' in the name is causing an issue querying the data. I've tried it with the IP address and the same thing happens as it looks like it only wants to see a character string without punctuation.Has anybody else come across this or knows how to overcome this problem. I can't rename the SQL server instance.ThanksDave |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2010-01-29 : 10:26:45
|
| try putting the name in brackets [sql-server-v01]Mike"oh, that monkey is going to pay" |
 |
|
|
bendertez
Yak Posting Veteran
94 Posts |
Posted - 2010-01-29 : 10:40:35
|
| Of course, thanks Mike |
|
|
|
|
|
|
Another Linked Server Query.....