Most RecentMost ViewedMost LikesAggregate data cross multiple Azure SQL Databases Hi Everyone, I am clear on setting up and running an elastic query. I am trying to understand how to run an elastic query across multiple databases and return an aggregated result. Any assistance is much appreciated. Thanks Lesson Learned #9: sp_execute_fanout was deprecated and replaced by sp_execute_remoteFirst 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.