Check in sysjobs for snapshot jobs of the old publications. I think that when reinstalling replication or droping publications, some objects where still created and that's why you cannot re...

If you need to have the clone db continuosly with the last changes, you should choose between log shipping and replication.

  Wich one is better will depend of how much...

To know the remaining time, execute kill spid. This will put the process in killed/rollback and will tell you the progress of the rollback.

If it is 100 % and o...

You could create an stored procedure wich executes the report you need and send the email to someone in all the servers you need.

Then in a central server or administration...

just execute  

drop procedure PRocName from the db where they belong.

please post the errors here if any.

Select the code that you want to comment, then Ctrl + Shift + C comments all the text. To uncomment, select the text and Ctrl + Shift + R.

What do you mean by upgrading your db, applying new service packs?

With Service Packs you should read the notes that come with it to understand in wich order you need...

Both log shipping and replication could be good choices, but better cluster server of course.

If you are going to use replication then I would suggest to use Transactional.

You can create...

if you are first sincronizing with the snapshot, also check space in the system disk (where your temp folder is) because SQL first extract every snapshot file into that folder.

If you set replication in SQL, then you won't be able anymore to truncate the tables, you will have to delete them, wich means that all the deletes will replicate...

Never see them, but does iss log file have some structure? Are separated in columns?

If not, can use a DOS command like more with xp_cmdshell to read the file and...

Use sp_repladdcolumn.

Use sp_repladdcolumn.

Is the snapshot agent job running?

If not, start it manually to change the status.

If you reinitializec the subscription, maybe the snapshot was told not to regenerete the sp. And that's why it failed again after re applying.

You can use sp_scriptpublicationcustomprocs to regenerete all...