Hello @Dnirmania,
The error message "single-row subquery returns more than one row" indicates that a subquery used in your REFRESH FOREIGN SCHEMA command is expected to return only one row, but it is returning multiple rows. This is a common SQL error that occurs when a subquery is used in a context where only a single value is expected, but the subquery returns multiple values.
Ensure that the subquery returns only one row. You can do this by:
- Using an aggregate function like MAX(), MIN(), or TOP 1 to limit the result to a single row.
- Adding a WHERE clause to filter the results so that only one row is returned.
Check for Duplicates: If the subquery is supposed to return a unique value, ensure that there are no duplicate values in the data that the subquery is querying.