SQLNightOwl (2/16/2016)

---

Chris Quinn-821458 (2/16/2016)

---

In the UK if a holiday such as Christmas Day, Boxing Day or New Year's day falls at the weekend, the public (bank) holiday always moves to...

In the UK if a holiday such as Christmas Day, Boxing Day or New Year's day falls at the weekend, the public (bank) holiday always moves to the start of...

As I always say, it ain't the tool that is used that's the problem, but the tool that uses it.

Huge numbers of bank ATM systems run on XP based systems, so generalisations saying its not fit for use are pointless.

Are you saying that Linux doesn't get seasick?

I presume you mean this one?

http://www.sqlservercentral.com/articles/SQL+elapsed+times/101971/

I shall read and digest it!

The dates and times we get are provided by an external source and do not contain the offsets, so we would need to derive these from location, from a lookup...

The log shipping is set to leave the target in standby mode, but when it goes wrong it seems to be leaving the database in no recovery mode

A restore of the offending transaction log worked.

I have noticed that the database, when the log shipping fails, is shown as "Restoring" in the database list, so has the previous...

Each database saves to the same location on a NAS drive, but into a database specific subdirectory, and the SQL service has full permissions to the location

The files exist and are being copied correctly every 15 minutes

That looks perfect!

Many thanks! Works perfectly

You need to group by just the date portion of CHECKTIME - try this or similar

SELECT inf.SSN AS EmpNo, Format(ck.CHECKTIME, "dd/mm/yyyy") AS CHKDATE,Min(ck.CHECKTIME) AS TIMEIN, Max(ck.CHECKTIME) AS TIMEOUT

...

I think I have discovered something that is possibly significant!

As stated previously, the data is a set of key/value pairs, with a datatype (D = Date, N= Number, S =...