Thanks, closing for now.

Did you mean sys.fn_varbintohexstr()?

Mostly, habit. datetime comes up first in intellisense, shorter to type, old habits.

I  go back and forth. I'm trying to be better with declarations like explicitly using datetime2(3),...

SQL Server Data Tools from MS has a cut down version of SQL Compare.

Erikur has a quick solution, but there isn't a easy way to determine match quality or partial matching of different lengths.

How do you decide when 123 matches 1234...

I'm not completely sure what your setup is. You've written some ambiguous pronouns in your description. Can you set up a repro at all? what if you leave the existing...

We used to do something similar here. We tested DBMail, and it works, but it's not a great use of the server resources if you need them for queries.
There...

Resources added to the article at the bottom

I'm torn here. On one hand, I think we need updates, and need some forcing of updates. Far, far too many people don't update and let systems languish for years....