The problem with copying the tables and using a view is the plan is to consolidate and minimize the tables being used for the production applications.

Does this apply to SQL 2000?

I dont suppose I could replicate a view to dump data into a table?

I only need to modify the replication trigger for each individual database to replicate data to the standard structure and schema invidually from there I will use replication to consolidate...

How can I tell what I am using? I used the setup wizard

A view is not going to accomplish what is being requested.

So there isnt a way to customize the replication trigger to accomodate for the different field order?

I am using SQL 2000 to accomplish this and I dont see an option for Default Binding.

So if Default Binding doesnt work there is no way to accomplish a consolidated...

The structure cant be changed because of the fact that there are custom applications written and compiled that could potentially be using SELECT * somewhere and the people who would...

Oh I forgot to add its only one subscriber subscribing to the four publications

I have a unique way of identifying the records, what I need is to be able to accomodate for columns being out of order. How would I setup replication...

Yes I am replicating a table from 3 different servers databases its an order table

In the table all the columns are the same its the column order that differs.

one...

Okay the table of tasks sounds like what I am trying to accomplish. How would I go about implementing this?

I was trying to test this solution out but I get an error stating I am missing the sp_SMTPMail object. Any chance you could script the one you have?...

I didnt think I was going to find anything like that, seeing as how I couldnt on Technet or BOL. Just thought I would throw it out there and...

Yeah I have seen that article. I was hoping there would be something that states that transaction logging is controlled at the database level by selecting the proper recovery...