No apology needed. Thanks for posting the solution

Original way to put the brakes on. Get better soon Jasona.

For recovery you can train your hand with edge-browser easteregg edge://surf/

I applaud to all persons who have kids at home or other people /things that demands immediate attention.

We can still go outside, which is a plus

You might want to verify the integrity of the sql 2000 backup with dbcc checkdb

Not sure when page verify Checksum was introduced (better than torn-page detection) for corruption detection

https://www.sqlskills.com/blogs/glenn/setting-your-page-verify-database-option-to-checksum/

Me neither, apparently EDI-files https://en.wikipedia.org/wiki/X12_Document_List

Recommendations: keep it within the applications specs.

Downside of having nvarchar too big:

More memory reserved in applications / sql server for retrieval of data as each field can hold more data.

No...

Thanks for mentioning sys.dm_db_persisted_sku_features, didn't know it existed

I personally dislike single letter aliases, usually too short to have a representative meaning. With a as (), b as (), c as (), d as ()  . Select ......

SELECT REPLACE('ABC*1234','*','00000') newvalue

Probably there is a filter active on tablix, dataset, ... Do you have the same problem in a blank report with just the sp?

Use synonyms, views on srv 2 ? Srv3 queries srv2 (which queries srv1)

Music is certainly a help to cope with the isolation. Rediscovering my cd-collection and noting down some of the better songs

An exclusive lock on a table is quite drastic. Which isolationslevels are in play? http://thesqlgirl.com/2016/11/01/sql-transaction-isolation-levels/

We are also using Veeam to do our SQL backups.

1. It is possible to restore to point in time. Test it. We originally had some problems with timeouts on restoring...

You got me. Nice one