My Vista Windows Authentication login failed with Error 18456 after installing SQL Server 2005, while sa worked. Adding my login as administrator fixed it.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Find Table in Every Database of SQL Server – Part 2 Extension
Two more ways from Simon Worth to find table in every database of SQL Server, both built on sp_msforeachdb, one saving results to a temp table.
ACOS: Check the Cosine Domain Before Calculating Angles
ACOS calculates an angle from a supported cosine ratio. Keep invalid and missing inputs visible while displaying valid radians at a chosen scale.
PERCENT_RANK Versus CUME_DIST: What Ties Change
PERCENT_RANK versus CUME_DIST answers different ranking questions. Keep peers intact and compare missing scores and singleton groups.
NOT and NULL: Unknown Does Not Become True
NOT and NULL do not create a complete two-way classification. State whether missing values belong in a filter or a separate reporting category.
Writing a Good Technical Blog Post
A technical blog post works when it solves one problem with tested code, clear assumptions, a readable result, and honest limits.
SQL SERVER – Find Table in Every Database of SQL Server – Part 2
Part 2 of how to find a table in every database of SQL Server: this stored procedure loops through sys.databases and reads the Information_Schema view.
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.