New client, new idea and a new blog! That’s how I have been writing a daily blog for many years now. In this blog, I would share my learning from a client who faced error “xp_create_subdir() returned error 183, ‘Cannot create a file when that file already exists” while running maintenance plan.
SQL SERVER – FIX: Msg 15281 – SQL Server Blocked Access to STATEMENT ‘OpenRowset/OpenDatasource’ of Component ‘Ad Hoc Distributed Queries’
I wrote a blog earlier about reading data from excel via SQL Server. This was done using ‘OpenRowset. One of my blog readers sent an email to me that they were getting an error. In this blog, we would see how to fix Msg 15281 – SQL Server blocked access to STATEMENT ‘OpenRowset/OpenDatasource’ of component ‘Ad Hoc Distributed Queries’
SQL SERVER – Installation Stuck at Offline Installation of Microsoft Machine Learning Server Components
I was trying to install SQL Server 2017 on my latest formatted machine and was stuck at below screen which says – Offline Installation of Microsoft Machine Learning Server Components. In this blog, we would learn about how to move forward in the Installation when it is stuck at Offline Installation of Microsoft Machine Learning Server Components.
SQL SERVER – SETUP Error: The Syntax of Argument “/ACTION” is Incorrect
Recently, I was trying to uninstall SQL Server via command prompt and faced an interesting situation. In this blog, we would learn about the error “The syntax of argument “/ACTION” is incorrect” and how to fix it.
SQL SERVER – Unable to Uninstall – Index was Outside the Bounds of the Array
This was an interesting error which I received while trying to uninstall SQL Server. In this blog, we would learn how to fix error Index was outside the bounds of the array, which might come during uninstallation of SQL Server.
I must say this was an unfortunate situation where my machine got crashed while SQL Server install was in progress. To get rid of the “incomplete” installation, I decided to remove it and install it again. I went to add/remove program and selected “uninstall” for SQL Server 2017 as I was welcomed by error – Index was outside the bounds of the array. I looked into Summary.txt file and found below.
SQL SERVER – SQL Server Agent Missing in SQL Server Management Studio (SSMS)
Learning never stops when you are a consultant. While doing my recent Comprehensive Database Performance Health Check my client asked an interesting question. He informed that he is not able to see SQL Server Agent node in SQL Server Management Studio (SSMS). What could be the possible cause? I was able to provide him answers and sharing it here. First, let us understand what he meant. If you look closer at two SSMS connection. Do you notice a difference? Yes. As the title says – SQL Server Agent is missing in the second image. So, what are the possible causes?
SQL SERVER – 5061: FIX Error: ALTER DATABASE failed because a lock could not be placed on database ‘Database Name’. Try again later.
Every consulting engagement is different and I get to learn new things. In this blog post, I will share what I learned during my recent Comprehensive Database Performance Health Check. During health check to demonstrate one of the scenarios we had created a test database in our environment. However, after the test was complete we wanted to take the database offline so we eventually can drop it or bring it online if needed, however, as soon as we ran the command to take database offline, it gave is an error related to alter database failed because a lock could not be placed on database.