Can try something like this:

SELECT Job_Id, SUBSTRING(job_Desc,1, 500) + CHAR(13) + CHAR(10) + SUBSTRING(Job_Desc, 501, LEN(Job_Desc))

FROM Job

Can't do it directly. BCP doesn't copy column names.

Maybe if you create a temp table with the column names as records and also the data you need to export.

You can...

Agree. If you need to add procesors and/or memory and it exceeds the permited in the standard edition, then you should upgrade.

If possible run DBCC DROPCLEANBUFFER in both servers before running the sp. But be carefull because in production may be dangerous. Check in BOL for explanation.

Also check differences with indexes,...

Check the logins with

SELECT name

FROM master.dbo.syslogins

WHERE IsNTName = 1

Do you have any process wich runs them?

Do you have any sp wich uses sp_Start_job?

Check if any other job, runs them, or if you have any alert that executes them.

Are you using EM? With wich option.

Try DBCC SHRINKFILE instead.

At what time was your last log backup?

You could create a process wich bcp out all the tables that you need to .txt articles. If you can filter the data using any date column much better, so...

You can replicate image columns in transactional replication, but the validation that SQL uses it is a count from the table (or the rows columns in sysindexes) and a checksum....

Check if the sp uses any temp table (#) and if so, check the collation of the tempdb database.

If it is different with db that you try to compare, then...

No. You will have to create your own audit method. With sp to access tables, triggers or profiler.

You should check in script already posted in this site. There are many and some of them are very good.

It is a different version of the same stored procedure created by the replication because when tried to replicate with the first sp, it failed.

Then it will continue using the...

Did you try to rebuild the publication?

You will need to drop all subscriptions, re create the publication and then subscribe again.

It can take a long time, but most of the...