How to use Data Source in the script ?

Question

How to use Data Source in the script ?

jgnimje

SSC Journeyman

Points: 89
More actions
February 23, 2010 at 8:27 am

#143124

Hi,
In sql server 2000, I want to select the data of server 'B' from server 'A'. My restriction is I can't use linked server/table copy. I have been told that I can use data source. Any body can help me how to use data source in the script to access the data of server B from server A.
Thanks in advance,
Regards,
Jayant

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

Jayant i think they are refering to the OPENROWSET command; you can substitute SELECT * FROM YOURTABLE where i'm using EXEC dbo.sp_Who for the command

SELECT *

FROM OPENROWSET('SQLOLEDB','Server=yourservernamehere;Trusted_Connection=Yes;Database=Master',

'Set FmtOnly OFF; EXEC dbo.sp_Who')

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

jgnimje SSC Journeyman Points: 89 More actions · Answer 2

Hi Lowell,

Thanks a lot. I was searching for the same thing what you have given. It has really helped to build the logic I was looking for. Your help I can't express in words.

Thanks a lot once again.

Jayant

Lowell SSC Guru Points: 323518 More actions · Answer 3

thank you Jayant, I'm glad i could point you in the right direction with your project.

feedback like yours is exactly why I like to help here; knowing I got to help someone a little bit.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!