sql server connect: Have asp.net applic connecting to remote SQL Server. Is it possible to

A stored procedure on SQL Server instance A can execute a statement that
affects SQL Server instance B. Is that what you mean? On A, create a linked
server pointing to B. Then use 4 part naming ServerB.testDB.dbo.SomeTable to
do the work on B. Or, on A, execute a stored procedure on B as: EXEC
ServerB.testDB.dbo.MyProc
There are many variations on this. You don't have to create a linked server
if you use the OPENROWSET function, etc.
--
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]