That was a great question, took some research as I'd never heard of a marked transaction restore. Thanks

Isn't DAC connection on previous versions only available via sqlcmd rather than SSMS?

Sorry didn't like that one Steve, totally unfamiliar with the AT TIME ZONE command, and of course I got it wrong.

Doh!

Thanks Steve, easy one if you use SSIS all the while

Bit too easy that one Steve, but good not to have to use the brain this early in the day.

Thanks

Nice one

Easy one for the end of the week. I was looking for the gotcha but there wasn't one

Brain obviously not going yet!

I got the question right, but I thought the correct answered should have been qualified a bit more.

Didn't read the question very well missed the bit about one year ago, so disagreed with all the answers. But guessed at Today.

Doh!

I also didn't think any of the answers were correct as the order by was by CustomerId then TotalDue desc