Solved

Remote Query in SQL 6.5

Posted on 2000-04-25
1
214 Views
Last Modified: 2006-11-17
Hi,
I have two computers with sql server version 6.5. both of them have a databse called tmp.
i registred the first sql server to the other.
i want to run a script which query the second databse (on the remote server). i don't know how to define the other sql server. for instance

select * from RemoteServer.tmp ????
0
Comment
Question by:nirkr
1 Comment
 
LVL 6

Accepted Solution

by:
crsankar earned 100 total points
ID: 2746998
When you are using a remote query you have to use a a four part name as in

select * from server.database.user.table

e.g.

select * from remoteserver.northwind.dbo.products

Hope this helps


0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Join & Write a Comment

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now