What Is Federation Member?

1.	What Is Federation Member?
Answer» The federation MEMBER is the shard (i.e., the database containing a specific range of information). T-SQL script: USE FEDERATION ROOT WITH RESET GO ALTER FEDERATION &LT;Federation Name&GT; SPLIT AT (<DISTRIBUTION KeyName>=<script point>) The federation member is the shard (i.e., the database containing a specific range of information). T-SQL script: USE FEDERATION ROOT WITH RESET GO ALTER FEDERATION <Federation Name> SPLIT AT (<Distribution KeyName>=<script point>)

Answer»

The federation MEMBER is the shard (i.e., the database containing a specific range of information).

T-SQL script:

USE FEDERATION ROOT WITH RESET

ALTER FEDERATION &LT;Federation Name&GT; SPLIT AT (<DISTRIBUTION KeyName>=<script point>)

The federation member is the shard (i.e., the database containing a specific range of information).

T-SQL script:

USE FEDERATION ROOT WITH RESET

ALTER FEDERATION <Federation Name> SPLIT AT (<Distribution KeyName>=<script point>)

Discussion