Thanks, that makes sense. I did bit of further reading and it looks like an in situ upgrade is restricted more than a RESTORE.

SQL Server 2016 will restore from 2005...

I do not have "cross db ownership chaining" turned on ...

I have explicit permissions on the tables, in Other Database, that the APP needs access to.

But what I want to...

I thought it wasn't possible to upgrade SQL more than 2 version - so required multiple intermediate steps when coming from a much older version.

But on checking that I found:

"Backup...

We have an SProc that we put (EXEC) at the front of all scripts. Of course that is only Scouts Honour that it will be included ...

PRINT...

I have a Wacom Pen/Pad that I can use in TEAMS Whiteboard. I am no artist, and I find it very difficult to use (in the way of / as...

Yes, that's the intention, but given the Unique Clustered index...

Very helpful, thanks.

I'm too old to know...

More careful checking reveals some other sp_config values that are different to the Running values

min server memory (MB) value=0, value_in_use=16

priority boost value=1, value_in_use=0

user connections value=8, value_in_use=0

Just can't think why any...

Thanks both.  Seems like it was most likely an accidental change, but we are totally mystified as to how that would happen. We don't go messing with that stuff (like...

Thanks Ken, I'll give it a go 🙂

Thanks.  The real-world Stored Procedure includes a bunch of error handling and logging, which inline table-valued function wouldn't...

Ah, that sounds encouraging, thanks. I'll check out the blog links too. It looks a bit daunting, as a newbie, last time I looked!

Sorry, I was being facetious 🙂

Thanks Gail. Bit beyond my capability - I'm aware of EEs, had a brief look, but never tried to actually code one. If you can easily point me...

It would to me if you were OUTER JOIN'ing the KeyValue table 137 times in...