Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Communication between two servers Expand / Collapse
Author
Message
Posted Thursday, July 25, 2013 12:53 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, April 10, 2014 7:33 AM
Points: 14, Visits: 75
Hello,

I'm trying to pull information from server B into a temp table in a stored proc that does stuff and then inserts it into server A. The stored proc will be ran on server A.

The only problem is that i need to try to find a work around so that I'm not using sp_addlinkedServer because of the security rights that follow it ( i prefer not to deal with that mess).
I'm currently using OpenDataSource but having that long string at the end of every from statement looks sloppy.
I've tried to use OpenRowSet but i cant seem to get it to work, not to mention it will look sloppy like the OpenDataSource anyways.

Is their any other work arounds or any way to make more compact.

Thanks
Post #1477683
Posted Thursday, July 25, 2013 5:05 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 1:34 PM
Points: 234, Visits: 1,089
You could try creating a package in SSIS as another option...

Cheers

Vultar
Post #1477801
Posted Thursday, July 25, 2013 7:50 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, May 15, 2014 5:11 PM
Points: 6,067, Visits: 5,283
I would do it with an SSIS package.

CEWII
Post #1477827
Posted Friday, July 26, 2013 8:25 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, April 10, 2014 7:33 AM
Points: 14, Visits: 75
Thank you for the suggestion. However as i am new to SQL i think it would take to long to learn to use ssis and remake the whole proc.

Maybe on my next project.
Post #1478031
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse