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...
2013-01-23
1,395 reads
MSSQLFUN
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...
2013-01-21
765 reads
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...
2013-01-21
946 reads
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...
2013-01-15
34,392 reads
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...
2013-01-11
4,224 reads
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,472 reads
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,735 reads
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...
2013-01-07
1,681 reads
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...
2013-01-04
1,212 reads
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...
2013-01-03
735 reads
Blogs
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Access + ODBC Driver 18 + SQL Server 2025: ~150–250 ms per request
Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025...
The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Question of the Day
The ##MS_DatabaseConnector## User
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers