create distributed partition view in sql 2000
1. create table
2. create constraint
3. create link server
use security setting user: sa password:
4. create view in each server
notic: use sql 2000 sp3
use jdbc sp3
set network trust in notorn internet security.
start DTS and SQL , SQL Agent service

0 Comments:
Post a Comment
<< Home