what pro's cons would there be to having a linked server run a local stored proc against another sql server or create that stored proc on that other sql server and call it from there in the c# code.
i would think that calling the stored proc would be more efficient that running a linked server - but please let me know your thoughts. I'm not sure i can have permission to add a stored proc on that server, so possibly the linked server is the only solution - but if i can put a stored proc on that server should i?
thanks.
Jeff
anyone?|||One obvious thing to keep in mind is the performance. Depending on your network the executiion time could be different.
Now I am not sure if I understand your question. If you do not have permission to create the stored proc on the original server you would still need access to the underlying tables if you want to access them through server B, irrespective of whether its via stored proc or directly T-SQL.
|||well typically I associate using a linked server to pull data from something using openquery such as ibm as400 so my question is do i get access to put the stored proc on the remote sql server (not one of my groups sql servers), or do i ask for setting up a linked server to it and execute the stored proc from my local sql server using the linked server approach.
either way?
get access to put the stored proc right on the sql server and call it in c#?
use the linked server and call it in c#
Just looking for some reason why one way may be better than another, primarily performance, and reducing putting in another possible point of failure.
thanks,
JB
|||
info@.learnbartending.com:
Just looking for some reason why one way may be better than another, primarily performance, and reducing putting in another possible point of failure.
Those are exactly the reasons why you might want to put the proc directly where the data is.
No comments:
Post a Comment