--after googleing this to death I came up with the following that worked very well

--using the sp_addlinkedserver stored procedure, update master.dbo.sysservers table of the ---server you are on with the...

I have done this many times by setting up a DTS package to call the stored procedure and then write the results to an excel file.  The DTS wizard works...