Avi Niv

Randomized color report? So help my CODE!

Writing a Reporting Services report can be challenging, making you use the most of...

2014-07-01

1,660 reads

Generating Email Reports using XML

SQL Server has some handy features: one of those features is dbmail, which I tend to use less until I’ve...

2014-06-19

827 reads

Recently we deployed database mirroring in an environment with an Active Directory. The process is usually quite simple and straight-forward,...

2014-03-04

624 reads

Recently I was asked to investigate a timeout issue that was causing SSIS package executions to fail.
The timeouts seemed to...

2013-12-30

1,294 reads

I upgraded a SQL Server 2019 instance to SQL Server 2025. I wanted to test the fuzzy string search functions. I run this code:

SELECT JARO_WINKLER_DISTANCE('tim', 'tom')

I get this error message:

Msg 195, Level 15, State 10, Line 1 'JARO_WINKLER_DISTANCE' is not a recognized built-in function name.

What is wrong?