SALES: 1-800-867-1380


Updated: November 21, 2014

This topic is OBSOLETE. You can find the most current version in the SQL 14 Transact-SQL Reference. See FEDERATION_FILTERING_VALUE.

The current implementation of Federations will be retired with Web and Business service tiers.  Consider deploying custom sharding solutions to maximize scalability, flexibility, and performance.  For more information about custom sharding, see Scaling Out Azure SQL Databases.

Returns the federation filtering value for filtering connections.

FEDERATION_FILTERING_VALUE (‘distribution_name’) 

Specifies the name of the federation key.

Returns NULL when the connection type is not filtering or is to a database that cannot have a filtering type connection, such as a non-federated database.

Returns an error if the call is not well-formed, such as an invalid number of parameters or incorrect parameter type.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft