Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

FEDERATION_FILTERING_VALUE (Azure SQL Database)

 

Applies To: SQL Server 2014, SQL Server 2016 Preview

Returns the federation filtering value for filtering connections in Azure SQL Database.

System_CAPS_importantImportant

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.

Applies to: Azure SQL Database.

FEDERATION_FILTERING_VALUE ('distribution_name') 

distribution_name

Specifies the name of the federation key.

Returns NULL when the connection type is not filtering or the connection 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.

Community Additions

ADD
Show:
© 2015 Microsoft