Running SQLCMD gave me this SQLCMD error: Failed to load resource file SQLCMD.rll. Here is how I used Process Monitor to find the missing file.
Free Tools Worth Knowing for SQL Server Work
Free tools for SQL Server work include Microsoft editors, built-in diagnostics, and community scripts; learn the job each handles and its limits.
SQL SERVER – SQLCMD to Build Comma Separated String
A trick from Balmukund and Vinod at SQLBangalore: use SQLCMD to export a table’s data as a comma separated string. Here is how it works.
SQL SERVER – Execute Operating System Commands in sqlcmd
Tired of leaving sqlcmd to check something in Windows? Here is a simple trick to execute operating system commands while you are still in the sqlcmd prompt.
SQL SERVER – Automatically Store Results of Query to File with sqlcmd
Want to store results of query to file automatically without SSMS? Here is how to do it with sqlcmd and its -o option, step by step.
SQL SERVER – How to Set Variable and Use Variable in SQLCMD Mode
A reader asked how to pass a different table name each time in SSMS. I show how to set and use a variable in SQLCMD mode with :SETVAR, step by step.
Sharing Query Results From SSMS: Copy With Headers, Grids and CSV
Share SSMS results with copy with headers, text and file output, deliberate CSV quoting, and command-line exports for larger sets.