Hi All,

I am preparing for 70-229 and I am going through both TestKing and UCertify materials. Well for a particular question, I found two different answers from these two. I am giving here my question below:

You have two SQL Server 2000 computers named CORP1 and CORP2 where both use SQL server Authentication. CORP2 stores data that has been archived from CORP1. At the end of the month data is removed from CORP1 and transferred to CORP2. You are designing quarterly reports that will include data from both CORP1 and CORP2. You want the distributed queries as quickly as possible.

Now what three actions should You take:

(For both TestKing and UCertify the given options are same)

According to TestKing the answer is:

1)Create a stored procedure that will use the fully qualified table name on CORP2 to retrieve data.
2)On CORP1, execute the sp_addlinkedserver system stored procedure.
3)On CORP1, execute the sp_addlinkedsrvlogin system stored procedure.

According to UCertify the answer is:

1)Create a script that uses the OPENQUERY staement to retrieve data.
2)On CORP1, execute the sp_addlinkedserver system stored procedure.
3)On CORP1, execute the sp_addlinkedsrvlogin system stored procedure.

So there is a contradiction.

Please let me know if anybody has any clue.

Thanks.

They arent contradictorary in that they both give you an answer as to how to connect to another sql server on your network.

For example

SELECT * from corp2.database.dbo.table

is the same as

OPENQUERY(corp2, 'Select * from table)

in both cases though you have to call sp_addlinkedserver before you try to execute these commands.

I would say to just remember that both do the same thing then, regardless of what is on the exam, you will know that both do the same thing.

Hth

"The one language all programmers understand is profanity."