Re: Specifying which SQL Server to use

Check out "Linked Server" and [sp_AddLinkedServer] in Books Online. (instead
of the "Lined Server" Andrew mentioned) ;-)

Then use the 'four-part' object naming convention:

[ServerName].[DbName].[Owner/SchemaName].[ObjectName]

You are currently using a three-part name: Admin..Cases, with the two dots
assuming that the object is 'owned' by the current user. It would be
stronger to specifically itemize the 'owner/schema', as in: Admin.dbo.Cases

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx> wrote in message
news:%23Nf$wIV6GHA.2248@xxxxxxxxxxxxxxxxxxxxxxx
If you need to be able to query from one server to another you would have
to create a Lined Server and access that or use OpenQuery(). Both are
detailed in BOL. But if you simply need to run a query against each one
individually you can open a Query Analyzer window for each server. The ..
is outlined in BOL under the index entry for "object names" and then
"Object Visibility and Qualification Rules".


--
Andrew J. Kelly SQL MVP

"Todd Cary" <todd@xxxxxxxxxxxxxxxxxx> wrote in message
news:45265929.8020703@xxxxxxxxxxxxxxxxxxxxx
Under SQL Server Group, I have three registered servers:

(local) (Windows NT)
192.168.100.5 (Windows NT)
2K-SERVER (Windows NT)

Each server contains a database named "Admin" and each "Admin" database
has a table, "Cases".

In the following query, how would I specify the Server:

SELECT * FROM Admin..Cases

Second question:

Where in SQL Server Books online is the ".." as used above discussed as
well as other ways of specifying a database/table combination?

Todd




.

Relevant Pages

  • About ADAM and VB web application
    ... for do query about the values of 4 attribute. ... I have about 750 connect/sec on 6 different web server that point to my ... that every time that i try to connect a new socket was open so the nimber of ... At the moment i modified a number of socket that Windows 2003 maybe open ...
    (microsoft.public.windows.server.active_directory)
  • About ADAM and VB web application
    ... for do query about the values of 4 attribute. ... I have about 750 connect/sec on 6 different web server that point to my ... that every time that i try to connect a new socket was open so the nimber of ... At the moment i modified a number of socket that Windows 2003 maybe open ...
    (microsoft.public.vb.6.webdevelopment)
  • Re: Searching AD to determine account usage
    ... I haven't set it to Windows 2003 Server mode yet as I ... >> Is there a tool to query AD and report user login activity? ...
    (microsoft.public.windows.server.active_directory)
  • Re: Passing values
    ... Use the comma as the separator list (excerpt if you have set the Windows' ... menu for the Queries Window. ... You can also use a view and set the Server Filter but that's another story. ... > figure out how to pass a value from a form to the query. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Restricting Logons with Windows 2000 Server
    ... Ideally I would like to specify at the workstation level who is ... We have a plain Windows 2000 Server / Windows XP Workstation ...
    (microsoft.public.windows.server.general)
Loading