Resolved by rebooting the server, in case anyone ever needs to know.

Not permissions related, my account has SA privilege's on the server in question.

Thanks for your reply, but Pinals article describes a fix to the opposite of the problem I'm having.

All of the articles I've been able to find describe the reverse of...

Thanks for the reply Ken, I'll exclude the rowversion columns and look into using the ToBase64String function.

Thanks excellent, thanks very much for the detailed reply.

Thanks Frederico I've had a play and done some more research online so I have a better understanding now, and you're right I do need some more PowerShell practice.

I'm still...

Thanks Steve, simple and effective. Makes me wonder why I didn't think of it first. I was originally thinking of going with DBATools polling services and logging to tables etc....

Thanks Grant, there's already some homegrown monitoring in place for basic metrics like agent job failures and disk space etc. Unfortunately, and as usual, there is no budget for purchasing...

I followed the Ryan Adams blog post on building a cluster in Hyper-V a few months ago. I've been working with clusters for years but had never actually built one...

Thanks for your reply Jeff. I'm no closer to getting to the bottom of this one but I've since discovered this particular database is configured for log shipping and transnational...

FYI - We finally resolved this, the solution was an upgrade of VMWare tools. Go figure hey.

Never mind, this is just a place holder, the client manually inputs this value.

Thanks guys.

Thanks for you reply Grant (and thanks for SQL Server Execution Plans, very useful book).

I did notice a lot of contention on the table during the index maintenance and the...

Thanks for your reply Jeff.

The clustered index was %53 fragmented where the non-clustered was %41 fragmented.

I understand what you are saying but to summarize the sort operation had...

Thanks very much for you reply, that makes sense.

Hi,

From the error message "Login failed for user 'AD\DWPRODDB2$".

Have you checked this account is not locked out / disable etc?