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

Is SQL browser running?

I don't think you can limit it to a particular database. Security is handled with linked server login mapping and the destination can also block certain logins

https://docs.microsoft.com/en-us/sql/t-sql/functions/openrowset-transact-sql?view=sql-server-ver15

• This reply was modified 5 years, 6 months ago by Jo Pattyn.

Glad you found your solution. Thanks for posting it