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

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

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

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

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

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

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

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

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

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

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

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

How to move file through FTP by CMD ?

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

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

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

MSSQLFUN – Year 2012 Review

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

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