What is the message stated in the [sysmail_event_log].[description] column if you execute the query below?

SELECT *

FROM msdb.dbo.sysmail_allitems

LEFT OUTER JOIN msdb.dbo.sysmail_event_log

ON sysmail_allitems.mailitem_id = sysmail_event_log.mailitem_id

ORDER BY

send_request_date desc

Is a anti-virus application blocking the mail?

What if you temporarily(!) turn off the firewall?

Was the server downtime on the SOURCE of the logshipping or on the TARGET?

You mention the LOG backups are created correctly. Are the LOG backup files being copied correctly? Are...

I think that is a going to be very complicated. When the line is commented using "--" you are able to match it with "AND NOT LIKE '%--%' ". But...

You are talking about a configuration of Windows Server. But you are posting this in a SQL Server forum. Many of the readers won't have the proper knowledge to answer...

Yes, a service pack is always applicable to all editions (standard, professional, etc.).

Yes

Restore FULL backup from day 2 (with standby mode) and then restore each LOG backup taken after this FULL backuip up until the point-in-time of your needs.

With the code below I am able to reproduce the same results. It looks like with this collation the "W" and "V" are treated as the same...

You can execute this command on-the-fly without effect on the current activities.

You can also change this setting in the GUI: go to the property of the database and select "Options"....

I can't reproduce it on my instance. What is the collation setting of your instance and your database?

Use the result_seperator option:

exec sp_send_dbmail

...

@query_attachment_filename = 'sample.csv',

@query_result_separator = ',',

...

To sent the results on a schedule, you can create a SQL Agent job and execute the sp_send_dbmail from a job step.

Most of the time it is no problem to...

Take a look at the "sp_send_dbmail" stored procedure and make use of the @query parameter.

http://technet.microsoft.com/en-us/library/ms190307(v=sql.100).aspx

Read Books OnLine and/or google a bit on the internet. You will find...

No, it does mean: nothing that need to be logged happened on that day