How to reference a sql server with a slash (\) in its name?
- by Bill Paetzke
Givens:
One SQL Server is named: DevServerA
Another is named: DevServerB\2K5
Problem:
From DevServerA, how can I write a query that references DevServerB\2K5?
I tried a sample, dummy query (running it from DevServerA):
SELECT TOP 1 *
FROM DevServerB\2K5.master.sys.tables
And I get the error:
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '\.'.
However, I know my syntax is almost correct, since the other way around works (running this query from DevServerB\2K5):
SELECT TOP 1 *
FROM DevServerA.master.sys.tables
Please help me figure out how to reference DevServerB\2K5 from DevServerA. Thanks.
