With the above help you can. But if you have setted up replication, then I would suggest to reinstall SQL, because it can get bad configured.

From the distributor, you must specify wich are the publisher that uses that distributor.

You can do it from EM, in the properties of Replication.

Who is the owner of the object?

Check if it is not dbo.

You have the option available from the publication properties. It is a parameter of the publicacion, not the subscriptions. Wich means all subscriptions on anyone.

In the sp_AddPublicacion sp in the...

Run KILL spid WITH STATUSONLY  from QA. If the rollback process is 100% complete and 0 seconds remaining, then it means that it won't rollback and you will have to...

Please, before posting possible solutions, check microsft link in my first post.

I have created the indexed views with the options sets to ON and didn't work. Now I have change...

Try this:

restore VERIFYONLY FROM [YourBackupDevice]

Multi Server Jobs, won't run in the master server. It is only for target servers.

To un a job in the master server, you must create it in local jobs.

Why do you need to do that??

Did you try restarting the SQL service, not just the agent?

Do you have recent backups of that database?

The fastest way to transfer data is to bcp out and then bulk insert in.

Before bulk insert, you must create the destination table.

To BCP you can use the -N parameter...

Run sp_helppublication and check the compress_snapshot column to be sure that the option is right.

I also use Do not lock tables during snapshot generation... and it works find for...

You could use checksum function to compare both data.

If the numbers returned are different, then changes where made.

You can try this:

SELECT COUNT(*) FROM (SELECT DISTINCT FieldA FROM TableA) AS A