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
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
Updated Mar 14, 2019
Version 2.0
Jose_Manuel_Jurado
Microsoft
Microsoft
