Home » CodeProject (Page 17)
Category Archives: CodeProject
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 the hotfixes released since the initial release of SQL Server 2008 SP3. Those who are facing severe issues with their environment, they can plan to test CU9 in test environment & then move to Production … Continue reading
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 that SQL Server really Reserve 1 user connection for DAC (Dedicated Administrator Connection). So I decide to show a demo for the same. I have changed the no. of User Connections to 1 & … Continue reading
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 connection to SQL server & error no. 2 while trying to open Management folder. Error 1 : Cannot display policy health state at the server level, because the user doesn’t have permission. Permission … Continue reading
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 or SQL Agent Job Owner ? Normally, We think its SQL Agent Service account user under which SQL jobs runs. But it’s not true in all cases, It depend on your Job owner permissions. If … Continue reading
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 but whenever user try to run SQL Agent job, it get below error message. We have Checked that SQL Agent job related DB role is properly given to user. Also, Job is working fine … Continue reading