You could save the string in multiple varchar (8000) variables, and then concatenate them when executing the xp_sendmail command.

The replication monitor will only show if you have the Server configured as a Distributor. Did you have the server configured as a distributor before? Maybe it was deleted and...

Did you made any changes to your distributor? Did you disable the replication?

If it fails and you need help with the restore process, here is many people who can give you advice.

Good luck!

You should read in BOL the available options, check REPAIR_REBUILD option wich is more secure or REPAIR_ALLOW_DATA_LOSS)

You should run from QA:

DBCC CHECKDB ('DbName', REPAIR_REBUILD)

If is not very time consuming, I...

Is you are worried about the lincense

then you should consider using MSDE. Wich is the engine (with some limitations)

of SQL Server. There are no problems in the license with this,...

When SQL starts a full backup it checks wich is the LSN (Log Sequence Number), and backup all the datafiles pages plus the transactions pending to be saved into the...

If you didn't do it, run again the DBCC CHECKDB command with the REPAIR_ALLOW_DATA_LOSS option. If it stills gives you errors, then I hope you have backups to restore...

You mail client must be configured to use MAPI.

I don't think you could use VSS with SQL because the objects are not save into independent files. You could create a job to periodically scripts the Sp and check...

Well I never heard of them. Where did you read them? I would say they are the data and log files of SQL (.mdf and .ldf), but I'm not sure.

...

Shout if you need help!

If you delete rows from a table, SQL will used the free space to new inserts from the same table or any athoer table.

quote: