One of my clients reported that he is trying to apply security patch for SQL Server clustered instance and it was failing. Since this is SQL 2005 instance, there is no official support available from Microsoft at this point. So, they contacted me. I asked to share setup logs and found a very interesting note.
SQL SERVER – Fix – Error 15240, Severity: 16, State: 2 – Cannot write into file
I always keep playing with my virtual machine which has SQL Server installed. Recently I was trying to apply the patch of SQL Server and I was surprised to see that SQL Server was not getting started after patching. The error was Error 15240 it cannot write into file.
How to Query Multiple SQL Server with a Single Query? – Interview Question of the Week #106
Question: How to Query Multiple SQL Server with a Single Query?
SQL SERVER – SSMS Tip – Using Drag and Drop Capability
SQL Server Management Studio is an interesting tool. The more you work, the more you discover tricks from it. It doesn’t come as a surprise to how I get to know something new whenever I talk with someone. People have figured out new ways to work with SSMS. In this blog, let me talk about something interesting that has been with SSMS for ages but lesser known. Let us see today a time about SSMS related to Drag and Drop Capability.
SQL SERVER – The Log Scan Number Passed to Log Scan in Database ‘master’ is not Valid
Let us learn in this blog how to fix The Log Scan Number Passed to Log Scan in Database ‘master’ is not Valid. Let us learn in this blog post.
SQL SERVER – Why Cluster Network is Unavailable in Failover Cluster Manager?
It’s always a good experience to visit customer sites and talk to people. Sometimes I get to see things outside SQL world as well. There is a lot to learn and I believe that I can do that by sharing what I learned. In this blog post we will discuss Why Cluster Network is Unavailable in Failover Cluster Manager?
SQL SERVER – Query to Get the List of Logins Having System Admin (sysadmin) Permission
Though the script sounded simple to me, but I found that there are lots of incorrect scripts available on the internet. Here is the one of the script I found to find out the details of the system admin.