Thanks! I need it after consolidating sql server into a new instance and wanted to compare the execution performance.

I need it to be as simple as possible as an additional...

great to see my scripts have been used! at least a looong time ago.

BCP OUT and BCP IN in the fastest and old fashioned export import method

You can use peer-to-peer SQL Server 2005 Transactional replication. This one allows changes made at both nodes and being replicated to all the subscribers in both directions.

Also, you can use...

Wich version and Service pack do you have in publisher, distributor and subscribers?

No. even you backup and restore tables like syspublications and sysarticles included in the published database, when you restore it, the database is not marked for replication and is not...

Are you sure you are referencing the same table with the same owner?

Try updating the table specifying the owner

UPDATE dbo.RESULTS SET TOTAL_VOTES = (OPTION1 + OPTION2 + OPTION3 + OPTION4...

Yes, the only restriction is the distributor first, after that, the order is the same.

Beware if someone is using linked server to a OLAP server because SP4 will cause problems....

They are separate virtual servers, so you can upgrade each instance separately that won't affect the others. I mean, upgrade all yuor instances but not the one that doesn't support...

Same here, backups of published databases and restore in another server can't give you any problems. Replication is not that complicated!

Well I would use merge replication, wich in fact was design for cases like yours. When connected, laptop users could download changes to local SQL databases and then, while disconnected,...

I would really consider on using transactional replication with immediate subscribers, there is another option that is to user bidirectional transacional replication.

I have used in prod and it has worked...

Did you try subscribing the same publication to a SQL2005 instance instead of 2000?

You shouldn't have any problems as long as you don't include the same article in more than one publication.

Well, I can be help full in cases you have very big publications and re applying the snapshot takes a very long time. I would really test it in my...