I know it's possible to call a stored procedure from a stored procedure, both within the same dB and in different dB's, but is it possible to call a SP that's on a different server? My gut says "definitely not. at least not easily." But I wanted to see if anyone had any thoughts on this before I pursue a different course of action.Lookup "Linked Server" in books online and you will get lots of information on linking servers, which should then allow you to execute the SP on another server.|||Do you have any examples or know where I can find some of a stored procedure that uses a linked server? thanks for the help!
jonathan|||Actually, I got it to work. Thanks again!
jonathan
No comments:
Post a Comment