SQL server 2000 fragmentation

microsoft.public.sqlserver.tools

7 Nov 2005 8:11 PM

Nada Sherief

hi,

i want someone to help me in solving a problem in sql server 2000
considering that i have a table named PROJ(JNO,JNAME,BUDGET,LOC) where JNO
is the primary key of this table
also this table is related to another one, where the other table has a foreign
key to this table.

i want to perform horizontal fragmentation:

I want to divide the table PROJ into 2 relations. Subrelation PROJ1 contains
information about projects whose budgets are less than $200,000, whereas
PROJ2 stores information about projects with larger budgets.

please try to send me the code (with comments) and a detailed step-by-step
of how to run this code so that i have these tables fragmented on the two
servers.

or if they don't need code, i hope you send me a step-by-step support of
how to do all these fragmentations on SQL server 2000.

Thanx all