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,387 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
759 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
938 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,371 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,145 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,447 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,725 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,668 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,204 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
726 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers