"The fill-factor value is a percentage from 1 to 100, and the server-wide default is 0 which means that the leaf-level pages are filled to capacity.

Fill-factor values 0 and 100...

No, you don't need a linked server for replication. I was thinking you could use linked server to run queries to compare data and verify replication is working.

Something as simple...

Do you have a linked server ?

Are you looking for missing/extra records ? Or need to check every column within records of the same key.

In other words, you need...

If you go into the "Advanced" section of the scheduled job, you can output errors to a log file. Sometimes that will give more useful information.

Would disabling the indexes be safer than deleting them ? If you found you needed them, enabling them would be faster than finding the code to run, and there's no...

When you set up replication, you generally also set up scheduled job to replicate data at a specified interval. You can get an alert if those jobs fail.

You could also...

Curious, why migrating to only 2008 ?

Replication ??

You can use Snapshot replication for...

I don't know about SOX, but for PCI compliance, we also wiped sensitive data from dev/test after restoring from Prod.

Solution:

I slightly modified Ulysses Brown's solution from here

http://www.sqlservercentral.com/Forums/Topic320752-5-1.aspx

giving me this:

--BUILD LIST OF Captured SQL Agent Jobs from Profiler GUIDs

--ASSUMES THAT YOU HAVE A PROFILER TRACE TABLE "xxProfilerTraceTablexx"

--ALSO ASSUMES "xxProfilerTraceTablexx"...

On page 2 of this thread, Sean Lange gives a simple example of dynamic SQL (vulnerable to sql injection), and a parameterized version of the same code.

http://www.sqlservercentral.com/Forums/Topic1566653-392-2.aspx

The "sp_whoisactive" tool show % complete. Not sure how accurate it is.

You could set up a server side trace to capture events for the future. I have 1 running 24/7 and have found it useful from time to time. I set...

Are both servers on the same domain ?