Either add a report header or footer, or create user parameters and assign them the values as an expression, I have personally not done the user params so cannot confirm...

I have the alocohol for the weekend lined up, 2 bottles of Innis & Gunn's, 2 bottles of Moorhouse brewery's Pendle Witches Brew and 2 bottles of Hoegarden Rose.

ToString() is not a valid method for the variables, if you want to convert it to a string use CStr

=CStr(Globals!PageNumber)

It generally wont I have found, usually down to parallelism where one thread is wating for others to complete, in that case while it is a waiting thread, its not...

Yes you will see blank login names for the same SPID in a parallel query, due to a SPID is linked to 1 user and 1 user only, so in...

Expand processes and filter on wait type non blanks

No backups? Why not?

What is the output from the following command

DBCC CHECKDB <Database Name> WITH NO_INFOMSGS, ALL_ERRORMSGS

Have you checked your DNS servers to ensure that the IP on the name record match and there fore resolving correctly?

Define what you mean as difference?

Difference in schema?

Difference in data?

Difference in purpose?

My definition of a staging database is somewhere to temporarly load data into in an ETL process before loading...

Either find the missing transaction log backup or re-initialise logshipping from a full/diff backup depending on the database backup routines.

Yes it is normal for it to delete log files.

The issue you have is that something or someone has done a manual transaction log backup or deleted a trn file...

sp_help_log_shipping_secondary_database @secondary_database = ''

Run that on the secondary server in master and it will tell you the last restored file, then you can investigate what went on.

You will need to do the LS configuration in one day if you are doing daily full backups. If you cannot do this then I would suggest taking a...

With something like the below

--CREATE A LOGIN WHICH WILL BE USED AS AN IMPERSONATION ACCOUNT FOR PEOPLE TO SEND MAIL FOR THIS TRIGGER ONLY

USE [MASTER]

GO

CREATE LOGIN [mail] WITH PASSWORD='', DEFAULT_DATABASE=[msdb],...

The LSN's are out of sync, it looks like either a manual transaction log backup was taken and not shipped or something deleted the transaction log before it was copied...