Given two Microsoft SQL servers:
Say ServerA has a view titled "View1":
SELECT * FROM ServerB.database.dbo.Table1 WHERE Column1 IN (1,2,3)
and a stored procedure "sp_Foo":
SELECT * FROM View1 WHERE Column1=1
When I execute
EXEC sp_Foo, which query is executed on which server? Are they all executed on ServerB? All on ServerA? Or is the view query executed on ServerB and the SP query executed on ServerA?