To pass parameters to a stored procedure, write the values after EXEC without parentheses, and name each parameter so the order can’t matter. This post builds a small order procedure and calls it by position and by name, with defaults, an OUTPUT value and a table-valued parameter. It also shows the three errors people hit first and what each one means.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Running CHECKDB with Minimum Repair Level
CHECKDB found 39 consistency errors and said repair_allow_data_loss is the Minimum Repair Level, but the reader could not finish the repair. Here is my reply.
What does BACKUP WITH NAME Command do? – Interview Question of the Week #130
What does BACKUP WITH NAME do? It simply names your backup, and you can then find that name in the msdb backupset table. Here is a quick example.
SQL SERVER – An Error Occurred While Obtaining the Dedicated Administrator Connection (DAC) Port
A student could not connect with the Dedicated Administrator Connection (DAC) after my class. Here is the port error he saw and how to fix it.
SQL SERVER – The Patch Installer has Failed to Update the Shared Features
Under a tight downtime window, a client got “The patch installer has failed to update the shared features”. Here is what the logs showed and how we fixed it.
How to Get Column Names From a Table in SQL Server
To get column names from a table in SQL Server, query sys.columns with OBJECT_ID, or read INFORMATION_SCHEMA.COLUMNS. This tutorial tests four methods on a demo table, shows the schema trap that returns too many columns, and builds a paste-ready column list. It also finds every table that has a given column.
SQL SERVER – FIX: Rule “Reporting Services Catalog Database File Existence” Failed
After a disaster, a client’s SQL Server setup failed the rule Reporting Services catalog database file existence. Here is why and how I got the install through.
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.