When the service account is removed from local Administrators group, SQL Server may not start. Here is why, and the minimal permissions it needs.
How to Pass Parameters to a Stored Procedure in SQL Server
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 – 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.