The EXECUTE permission was denied on the object 'sp_start_job', database 'msdb', schema 'dbo'.
Reblogged from MSSQLFUN:
Issue : Today I have read one issue over one forum, One user is having below 3 DB roles...
2013-01-09
5,438 reads
Blog Posts
What Queries From The Application Do To Your Plan Cache
Usually, a database is meant to serve some kind of application, and .Net applications have a few possible ways to query...
2013-01-09
1,175 reads
A Firm Foundation
Last week I sent out an invite for the monthly TSQL Tuesday party.
The theme for the party is a take...
2013-01-08
1,143 reads
A Firm Foundation
Last week I sent out an invite for the monthly TSQL Tuesday party. The theme for the party is a take on the words resolve or resolution. I was...
2013-01-08
7 reads
A Rickety Stairway to SQL Server Data Mining, Algorithm 2: Linear Regression
An algorithm that starts with the word “regression” seems an unlikely candidate to move forward with this series of self-tutorials...
2013-01-08
4,418 reads
Day 5 of 31 Days of Disaster Recovery: Dealing With Corruption in a Nonclustered Index
31 Days of Disaster Recovery
Welcome to day 5 of my series on disaster recovery. I want to start digging...
2013-01-08 (first published: 2013-01-06)
3,146 reads
Day 7 of 31 Days of Disaster Recovery: Writing SLAs for Disaster Recover
Day 7 of 31 Days of Disaster Recovery: Writing SLAs for Disaster Recovery
31 Days of Disaster Recovery
Today is day...
2013-01-08
1,564 reads
Day 8 of 31 Days of Disaster Recovery (T-SQL Tuesday #38): Resolutions for All DBAs
T-SQL Tuesday #38
This post is not only day 7 of my 31 Days of Disaster Recovery series, it is...
2013-01-08
1,345 reads
Fast Starts
We are barely under way with the New Year and it is shaping up to be a busier year already....
2013-01-08
992 reads
Fast Starts
We are barely under way with the New Year and it is shaping up to be a busier year already. Not quite as busy as has been published by...
2013-01-08
1 reads
Blogs
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
Forums
is it true we cant debug c# scripts in ssis anymore under vs
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
Missing the Jaro Winkler Distance
Comments posted to this topic are about the item Missing the Jaro Winkler Distance
Question of the Day
Missing the Jaro Winkler Distance
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? See possible answers