MSSQLFUN

The 9th cumulative update release for SQL Server 2008 Service Pack 3 is now available. Cumulative Update 9 contains all...

2013-01-23

1,376 reads

SQL Server Reserve 1 user connection for DAC (Dedicated Administrator Connection)……want to confirm ?

by Rohit Garg

MSSQLFUN

Sometime before, I was giving training on basics of SQL Server. One of attendee is having doubt & want to confirm...

2013-01-21

757 reads

Reminder about your invitation from Rohit Garg – MCTS, Microsoft Community Contributor

by Rohit Garg

MSSQLFUN

This is a reminder that on January 14, Rohit Garg – MCTS, Microsoft Community Contributor sent you an invitation to become...

2013-01-21

937 reads

The server principal “xxxx” is not able to access the database “msdb” under the current security context.

by Rohit Garg

MSSQLFUN

Problem :
Yesterday Night, One of my team member called & report that some users are getting below error no. 1 while...

2013-01-15

34,364 reads

Under which user your SQL Agent Job run : SQL Agent Service Account or SQL Agent Job Owner ?

by Rohit Garg

MSSQLFUN

Today, I am willing to do demo that under which user my SQL Agent Job run, SQL Agent Service Account...

2013-01-11

4,073 reads

The EXECUTE permission was denied on the object 'sp_start_job', database 'msdb', schema 'dbo'.

by Rohit Garg

MSSQLFUN

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,436 reads

The EXECUTE permission was denied on the object ‘sp_start_job’, database ‘msdb’, schema ‘dbo’.

by Rohit Garg

MSSQLFUN

Issue : Today I have read one issue over one forum, One user is having below 3 DB roles on MSDB...

2013-01-09

10,717 reads

How to move file through FTP by CMD ?

by Rohit Garg

MSSQLFUN

CMD code to upload file direct into root of FTP site of server
@ echo off
REM ******** this batch file is to...

2013-01-07

1,665 reads

What happen, If SQL Server new instance try to use exitsing named instance name?

by Rohit Garg

MSSQLFUN

We all know that SQL Server can have 1 default instance & many named instance.
But I want to check, How SQL...

2013-01-04

1,203 reads

MSSQLFUN – Year 2012 Review

by Rohit Garg

MSSQLFUN

The WordPress.com stats helper monkeys prepared a 2012 annual report for this blog.

Here’s an excerpt:
600 people reached the top of...

2013-01-03

717 reads

MSSQLFUN

Cumulative Update – 9 for SQL Server 2008 Service Pack 3 Is Now Available !

SQL Server Reserve 1 user connection for DAC (Dedicated Administrator Connection)……want to confirm ?

Reminder about your invitation from Rohit Garg – MCTS, Microsoft Community Contributor

The server principal “xxxx” is not able to access the database “msdb” under the current security context.

Under which user your SQL Agent Job run : SQL Agent Service Account or SQL Agent Job Owner ?

The EXECUTE permission was denied on the object 'sp_start_job', database 'msdb', schema 'dbo'.

The EXECUTE permission was denied on the object ‘sp_start_job’, database ‘msdb’, schema ‘dbo’.

How to move file through FTP by CMD ?

What happen, If SQL Server new instance try to use exitsing named instance name?

MSSQLFUN – Year 2012 Review

Blogs

Claude Code Helps Analyze Test Data Manager Log Files

PowerPoint to HTML with Claude AI

Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!

Forums

Is it uncommon for Dev's to have a data model of the source data

ROLLUP to calculate Month total for all Categories

Level 28: DAX Text Functions: The DAX Extract & Modify Functions: LEFT(), RIGHT(), MID(), REPLACE(), SUBSTITUTE()

Question of the Day

Creating JSON I