Query a Virtual Server

#1

I am trying to query the following table.

Select @@servername outputs : TEXBDVS01VSQL3\VSQL_XYZ

select * from TEXBDVS01VSQL3\VSQL_XYZ
...dbo.MORE_Test.MOREdatabase

I received the following error: Incorrect syntax near '\'

Please help me resolve this issue.

Thank You,

Frank

#2

select * from [TEXBDVS01VSQL3\VSQL_XYZ].dbo.MORE_Test.MOREdatabase

You enclose instance and virtual server names in brackets.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
CareerBuilder.com

"Frank" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

I am trying to query the following table.

Select @@servername outputs : TEXBDVS01VSQL3\VSQL_XYZ

select * from TEXBDVS01VSQL3\VSQL_XYZ
..dbo.MORE_Test.MOREdatabase

I received the following error: Incorrect syntax near '\'

Please help me resolve this issue.

Thank You,

Frank

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Query a Virtual Server

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering

Query a Virtual Server - 12-05-2003 , 06:17 PM

Re: Query a Virtual Server - 12-06-2003 , 10:17 AM