Sorry, keyword habit of capitalizing those.

Corrected.

Take it. Be aware, the queue is a little backed up for the next week or so.

And clean socks. Towel, toothbrush, and socks.

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...