i have an requirement where i need to create a indexed view with a table which is available in different server. but i get an error as Remote access is not allowed from within a schema-bound object. I understand this problem.
but i want to create as it is. i can create the same table in the database where am creating the indexed view. but i do not want to do that. i need an solution on how to handle it.
so that i can save on lot such views