yes

Thanks. Where can I find the stored procs to setup the replication on the subscriber running on sql 7.0

Thanks a lot Sreejit that helped a lot..I am gettin a readable output file now...

No luck guys.....I am still tryin.......this is the output format i want.

column1                                 column2                       column3

-------------------------------------------------------------------

data.....                                  data......                      data.........

data.....                                  data......                      data..........

Is there any way i have a formatted preprocessed file....and just have the output...

Ok

   let me give it a shot and see if it works...

thats wht i told my manager...but he insists he want a txt file.......