Home Forums SQL Server 2008 T-SQL (SS2K8) Send rows of data to stored procedure in linked server RE: Send rows of data to stored procedure in linked server

  • I would really have to see the data flow here as a diagram. If proc B is calling proc A (after already being ran), what is proc A doing this time? Is it going to insert data back into table A? what happens to the data that was already residing there? Updated? Appened to? It seems like you would go into a loop here. I would venture to say that whatever that proc on server B is doing, you can create it over on Server A at the very least. I would have to know more to give sound advise.

    ----------------------------------------------------