The EXECUTE permission was denied on the object ‘sp_start_job’, database ‘msdb’, schema ‘dbo’.
Issue : Today I have read one issue over one forum, One user is having below 3 DB roles on MSDB...
2013-01-09
10,725 reads
Blog Posts
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,447 reads
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 on the words resolve or resolution. I was...
2013-01-08
8 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,145 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,424 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,162 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,577 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,346 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
3 reads
Blogs
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database
By gbargsley
One of the first things I review when I inherit a new SQL Server...
AgentDBA vs Critical SQL Server
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
Forums
Increment a number in a SQL Query based on a value
I have an issue where I have a Bill of Material list of items...
Follow Your Hunch
Comments posted to this topic are about the item Follow Your Hunch
What Happens When You Ask a Local AI to Query Your Database?
Comments posted to this topic are about the item What Happens When You Ask...
Question of the Day
Detecting Characters
I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code:
SELECT CustomerNameID,
CustomerName
FROM dbo.CustomerName
WHERE CustomerName = LOWER(CustomerName)
Here is the sample data I am testing with:
CustomerNameID CustomerName 1 John Smith 2 Sarah Johnson 3 MICHAEL WILLIAMS 4 JENNIFER BROWN 5 david jones 6 emily davis 7 Robert Miller 8 LISA WILSON 9 christopher moore 10 Amanda TaylorHow many rows are returned? See possible answers