Lesson Learned #9: sp_execute_fanout was deprecated and replaced by sp_execute_remote
Published Mar 13 2019 06:16 PM 899 Views
First published on MSDN on Dec 28, 2016
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

Version history
Last update:
‎Mar 13 2019 06:16 PM
Updated by: