Msg 15281 appears when OPENROWSET or OPENDATASOURCE runs while Ad Hoc Distributed Queries is turned off. A reader hit it while reading an Excel file. Two sp_configure calls turned the component on, and the query worked.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Installation Stuck at Offline Installation of Microsoft Machine Learning Server Components
My SQL Server 2017 install got stuck at Offline Installation of Microsoft Machine Learning Server Components. Here is why it happens and how to move forward.
SQL SERVER – SETUP Error: The Syntax of Argument “/ACTION” is Incorrect
Uninstalling SQL Server from the command line, I got: The syntax of argument “/ACTION” is incorrect. Here is what the error means and how to fix the command.
SQL SERVER – Unable to Uninstall – Index was Outside the Bounds of the Array
My machine crashed mid-install, and uninstalling SQL Server 2017 then failed with: Index was outside the bounds of the array. This is how I cleaned it up.
SQL SERVER – The OLE DB Provider “Microsoft.ACE.OLEDB.12.0” for Linked Server “(null)” Reported an Error. Access Denied
OPENROWSET on an Excel file gave: The OLE DB provider “Microsoft.ACE.OLEDB.12.0” for linked server “(null)” reported an error. Access denied. Here is the fix.
SQL SERVER – Small Backup for Large Database
A client’s 900 GB database made a backup of under 300 MB, and they feared data was missing. Here is what explained the small backup for a large database.
How to Start Database in a Single User Mode? – Interview Question of the Week #202
How do you start a database in a single user mode when there is corruption? Here are simple steps in SQL Server Configuration Manager, one by one.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.