SQl server 2000 vertical fragmentation

microsoft.public.sqlserver.tools

8 Nov 2005 2:08 AM

Nada Sherief

hello

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 vertical fragmentation (partitioning) on SQL server 2000:

as an example take the relation PROJ and divide it vertically into two subrelations
PRO1 and PRO2. PRO1 contains only the information about project budgets,
whereas PRO2 contains the project names and locations.

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