sqlcmd.exe

SQL Server Command Line Tool - sqlcmd

CPU Usage

N/A

Memory

N/A

Location

N/A

Publisher

N/A

License

Part of SQL Server Client Tools; included with SQL Server installations or downloadable as SQLCMD client utilities

Publisher

Microsoft

Compatibility

sqlcmd.exe is versioned to match SQL Server clients; use a matching client version for best compatibility with your server

Adoption Guidance

For modern scripting, consider using Invoke-Sqlcmd in PowerShell as an alternative or complement to sqlcmd.exe

Security Considerations

Install only from official Microsoft sources; verify digital signatures; avoid running from untrusted folders or temporary locations

What is sqlcmd.exe?

sqlcmd.exe is a Microsoft SQL Server command-line tool that lets you connect to a SQL Server instance, run Transact-SQL statements, execute scripts, and automate routine tasks from a console or script. It's widely used by DBAs and developers for fast, GUI-free administration and automation.

sqlcmd.exe communicates with SQL Server using the Tabular Data Stream protocol. It accepts options like -S for server, -U/-P for login, -Q for a query, -i for input files, and -o for output, with -b to stop on errors and -m to control messages.

Is it Safe?

Is it a Virus?

Why is it Running?

Reasons it's running:

Automated maintenance tasks: SQL Server Agent jobs, deployment scripts, and automated maintenance routines frequently invoke sqlcmd.exe to run T-SQL scripts and manage databases without a GUI.
Ad-hoc administrative queries: DBAs or developers may manually run quick one-off queries or tests from the command line using sqlcmd.exe to verify results fast.
Application tooling and installers: Installers, migration tools, and application setup processes may call sqlcmd.exe to initialize schemas or populate data during deployment.
Data migration and ETL steps: ETL workflows or data migration scripts call sqlcmd.exe to execute batches of T-SQL across environments as part of pipelines.
Remote administration: Administrators use PowerShell or batch files that invoke sqlcmd.exe to manage remote SQL Server instances from remote consoles.

Can I Disable or Remove It?

Common Problems

Common Causes & Solutions

The SQL Server Client Tools (including sqlcmd.exe) are not installed or installed in a non-standard location.: Install the SQL Server Command Line Utilities from the SQL Server setup or download the SQLCMD client and ensure PATH includes its Tools\Binn folder.
PATH environment variable does not include the sqlcmd Tools directory.: Add C:\Program Files\Microsoft SQL Server\Tools\Binn to PATH or invoke sqlcmd by full path.
Insufficient permission for the file or directory.: Run the shell as Administrator or adjust NTFS permissions to allow your user or service account.
Wrong credentials or server configured to reject the provided authentication method.: Provide correct -U/-P or -S parameters, ensure SQL Server allows SQL authentication, and check firewall settings.
Script errors or batch abort conditions (especially with -b).: Review error messages, run with -m to control severity, and break scripts into smaller chunks for debugging.
Large scripts or queries cause long execution and result handling.: Optimize queries, limit result sets, use -a and -l for buffering, or run heavy work through SSMS or other tooling.

Frequently Asked Questions

What is sqlcmd.exe and what is it used for?

sqlcmd.exe is Microsoft SQL Server's command-line tool used to execute T-SQL statements and scripts against a SQL Server instance, enabling automation and scripting without a GUI.

Is sqlcmd.exe a virus or malware?

No, sqlcmd.exe is a legitimate Microsoft tool included with SQL Server Client Tools. Verify the digital signature and install source to ensure authenticity.

How do I run a script with sqlcmd.exe?

Use options like -S server, -i input_file.sql, -o output.txt, and optionally -U/-P for authentication. Example: sqlcmd.exe -S myserver -i script.sql -o results.txt.

Where is sqlcmd.exe installed on Windows?

Common locations include C:\Program Files\Microsoft SQL Server\Tools\Binn\sqlcmd.exe or C:\Program Files\Microsoft SQL Server\Client Tools\Tools\Binn\sqlcmd.exe, depending on the SQL Server version and tools chosen during install.

How can I fix 'sqlcmd.exe not recognized' errors?

Ensure the Tools\Binn directory is in your PATH or call sqlcmd.exe by its full path. If not installed, install the SQL Server Command Line Utilities.

Can I use sqlcmd.exe from PowerShell?

Yes. You can call sqlcmd.exe from PowerShell just like from CMD, and you can pipe or capture its output for further processing.

Related Processes

SQL Server Database Engine service that hosts and manages databases.

Legacy command-line tool for SQL Server that predates sqlcmd.exe (mostly deprecated).

Bulk Copy Program used for fast data export/import between SQL Server and data files.

Windows PowerShell host often used to invoke sqlcmd.exe in scripts and automation workflows.