Covert them into datetime & compare.

Look into Distributor's sql agent jobs.

What kind of answer it is? He is asking for permission required to create Transactional replication.

Only members of the sysadmin fixed server role can set this up from end...

Use Activity monitor to see what is going on when you see CPU jumped to 96%.

Also I would recommend using Adam Machanic sp_whoisactive, to see what is going on.

You can...

There is very excellent blog post by Kendra Little @brentozar.com

See if that could help.

http://www.brentozar.com/archive/2012/03/how-decide-if-should-use-table-partitioning/

SELECT sysjobhistory.server,sysjobs.name AS job_name,

CASE sysjobhistory.run_status

WHEN 0 THEN 'Failed'

...

If you post table script and script to insert some sample data that will be very helpful.

I am using office 2010 and it works fine for me.

Below are all the steps you have to do.

1)

EXEC sp_changepublication

@publication = 'PublicationName',

@property = N'allow_anonymous',

@value = 'false'

GO

EXEC sp_changepublication

@publication = 'PublicationName',

@property = N'immediate_sync',

@value = 'false'

GO

2) Add table to publication :-

exec dbo.sp_addarticle...

Try using sp_msforeachdb.

Could you please post the exact error which you are getting?

Check this link.

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

Brent Ozar have this very useful and perhaps the best material online for virtualizaing SQL Server.

http://www.brentozar.com/sql/virtualization-best-practices/

Could you please post the table structure and attach a sample file?

You can initialize from backup. That is the best way to do replication for bigger databases because it eliminates all bcp generation hence locking/ blocking.