Lesson Learned #9: sp_execute_fanout was deprecated and replaced by sp_execute_remote

  • Article

Within Cross-Database Queries we have the option to run a procedure using parameters using sp_execute_fanout. This execution could be a Transact-SQL statement on a single remote Azure SQL Database or set of databases serving as shards in a horizontal partitioning scheme.

From time ago, if you try to execute sp_execute_fanout you will have an error that this function doesn’t exist.

This function sp_execute_fanout has been replaced by sp_execute_remote . Please, use the new one instead of sp_execute_fanout