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