Also, is this website on an intranet or on the internet?

The only issue is what geocoding method you need. There are more than a half dozen which all work for areas in say Florida, but for locations in New York...

Are you saying you changed the date of the system not that daylight savings time kicked in.

Not sure what does the comparison but yes I would disable replication during the...

Yes you can execute multiple SQL pieces. More or less the input is a script just like QA works. You do not neccessarily have to put a GO in bu...

You might try a tool like Log Explorer which I do believe you can get all the updates and changes form the production systems transaction log without using replication.

Replication will...

Is this an Active Directory setup? Thre was a similar post in th past few weeks if it is.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=6&messageid=271375#bm272890

And see if it helps.

Then it depends on how much of the production server you need.

If all then perform a backup an restore to the test server.

If you just need a sampling of the...

Were the steps mixed up on the server when you opened the job or just in the script when output?

1) Have you verified what is takin all the CPU cycles and have you checked the Event Viewer logs for any issues before you assume the slowdown is in the...

First I would go back to the reason. Replication is usually for DR, building an Ad-Hoc reporting server and keepin synched, or a multitude of other things. What you are...

It cannot execute those items on the Oracle driver.

When you say "test" what do you mean. Testing reports and other queries or do you mean strucutre changes can be made such as index changes, table column changes, or...

Read Transactional Replication and Log Shipping in BOL.

Which type o replication are you using? And does the FK source data exist on both servers so that any data sent across will not fail?

Are the SQL Server and the Terminal Server in the same Domain? It sounds like a trust issue. You say however you setup the accunts as administrator and they can...