since the tables have different structures I doubt if replication will work. You could dig into the sp_MSinsert/update/delete stored proc generated by the replication wizard and mess with them but...

Please keep in mind that there is no specific order in which SQL stores data in the table. Farrell's solution will work if you insert all the rows manyally. You...

you should be able to drop the articles from subscriton. try this:

exec sp_dropsubscription @publication = 'pub_name'

, @article = 'Categories'...

based on what I understand you are trying to set the evox_id of nimages to the value from vehicle_tmp? If so perhaps something like this?

UPDATE ni

SET ni.evox_id = v.evox_id

FROM

nimages...

you dont "SET" , "IN". You set a value WHERE the ID is IN a given a list of values.

what exactly are you trying to do?

You would need to use IN instead of "=" in yout original query. I would check the result set first before doing the UPDATE.

If your DB has a static IP the user can register the DB through his local copy of SQL Server (I think the client tools are free to download). And...

You could create a job to do this. and use DTS packages to transfer data or even stored procs depending on the type of transfer - plain or with some...

Here's an article from an article I found:

SELECT Customers.CustomerId

FROM customers, orders

WHERE customers.Customerid *= orders.CustomerId

AND orders.CustomerId IS NULL

ORDER BY Orders.CustomerIdI need to see a list of customers who...

You can add columns using sp_repladdcolumn, without dropping the replication. check out BOL for more info on syntax.

Theoretically if you add the column on A, it would be propagated to...

I am not sure..but you can always run profiler and see whats being called..

I think Cover Letter is more like a personalized letter. You have all your skills and experience detailed out in the Resume/CV whatever you want to call it. Its a...

Can you rephrase your question as to what you mean by 2 remote servers?

check if they are enabled for replication. Under Publication properties check the list under Articles tab.

you can check the replication monitor status for the log reader and distribution agents history.