SQL Server Command Line Query Tool
What is SQL Server Command Line Query Tool? (from Microsoft)
You can manage your Microsoft SQL Server 2008 Express (SQL Server Express) databases by using the sqlcmd utility from the command prompt. To access the sqlcmd utility, click Start, click Run, and type sqlcmd.exe.
Overview
SQL Server Command Line Query Tool is a software program developed by Microsoft. The most common release is 9.00.1399.06, with over 98% of all installations currently using this version. Upon being installed, the software adds a Windows Service which is designed to run continuously in the background. Manually stopping the service has been seen to cause the program to stop functing properly. It adds a background controller service that is set to automatically run. Delaying the start of this service is possible through the service manager. The software is designed to connect to the Internet and adds a Windows Firewall exception in order to do so without being interfered with. The primary executable is named SQLCMD.EXE. The setup package generally installs about 159 files and is usually about 3.56 MB (3,735,104 bytes). Relative to the overall usage of users who have this installed on their PCs, most are running Windows 7 (SP1) and Windows XP. While about 66% of users of SQL Server Command Line Query Tool come from the United States, it is also popular in Israel and Germany.
Program details
Help link: go.microsoft.com/fwlink/?LinkId=52607
Installation folder: C:\Program Files\Microsoft SQL Server\
Uninstaller: MsiExec.exe /I{7BB17630-37A2-41FE-B347-474FD252C7F5}
(The Windows Installer is used for the installation, maintenance, and removal.)
Estimated size: 3.56 MB
Language: English (United States)
Files installed by SQL Server Command Line Query Tool
| Program executable: | SQLCMD.EXE |
| Name: | Microsoft SQL Server |
| T-SQL execution command line utility |
| Path: | C:\Program Files\Microsoft SQL Server\90\Tools\binn\SQLCMD.EXE |
| MD5: | 28731c04b854cc1570dbdacc89a6c3f2 |
Additional files:
-
msasxpress.dll - Microsoft SQL Server Analysis Services (Microsoft Compression Library)
-
msmdredir.dll
-
SQLCMD.EXE - T-SQL execution command line utility
-
atl80.dll - Microsoft® Visual Studio® 2005 (ATL Module for Windows (Unicode))
-
cmddef.dll - Visual Studio Environment Command definition DLL
-
compluslm.dll - Complus Library Manager Package
-
dbghelp.dll - Debugging Tools for Windows(R) (Windows Image Helper)
-
mfc80.dll - MFCDLL Shared Library - Retail Version
-
MFC80CHS.DLL - MFC Language Specific Resources
-
MFC80CHT.DLL
-
MFC80DEU.DLL
-
MFC80ENU.DLL
-
MFC80ESP.DLL
-
MFC80FRA.DLL
-
MFC80ITA.DLL
-
MFC80JPN.DLL
-
MFC80KOR.DLL
-
mfc80u.dll
-
Microsoft.Data.ConnectionUI.Dialog.dll - Microsoft Data Connection UI Dialog
-
Microsoft.Data.ConnectionUI.dll - Microsoft Data Connection UI
-
msvcp80.dll - Microsoft® C++ Runtime Library
-
msvcr80.dll - Microsoft® C Runtime Library
-
msvcr71.dll - Microsoft® Visual Studio .NET
-
msxmlsql.dll - Microsoft(R) MSXMLSQL 1.0 RTM (MSXMLSQL RTM)
-
AXSCPHST.DLL - Microsoft SQL Server (AxScriptHost - Active Scripting Host for SQL)
-
AXSCPHST90.DLL - AxScriptHost90 - Active Scripting Host for SQL
-
batchparser.dll - Batch Parser
-
batchparser90.dll
-
DISTRIB.exe - SQL Server Replication Distribution Agent
-
DTAttach.exe - SQL Server Integration Services Script Task
-
DTEParse.dll - Data Transformation Services Execution Utility Parser
-
DTEParseMgd.dll - Data Transformation Services Execution Utility Managed Parser
-
DTEPkg.dll - Data Transformation Services Execution Utility Package Processing
-
DTExec.exe - Data Transformation Services Execution Utility
-
DTS.dll - DTS - Data Transformation Runtime DLL
-
DTSComExprEval.dll - Data Transformation Services Expression Evaluator
-
DtsConn.dll - DTSCONN - Data Transformation Runtime Connections DLL
-
dtshost.exe - DTS - Runtime Surrogate
-
DTSLog.dll - DTSLOG - Data Transformation Runtime Log Providers DLL
-
dtsmsg.dll - DTS - Messages
-
DTSPipeline.dll - DTSPipeline - Data Transformation Pipeline DLL
-
DTSPipelinePerf.dll - DTSPipelinePerf - Data Transformation Pipeline Performance Counters
-
dtuparse.dll - Data Transformation Services Utility Parser
-
dtutil.exe - Data Transformation Services Package Utility
-
ExecPackageTask.dll - DTS - Execute Package Task
-
iftsph.dll - SQLServer Full Text Protocol Handler
-
impprov.dll - Import OLE DB Provider for SQL Server
-
instapi.dll - SQL Server Instance API DLL
-
instapi10.dll
-
instapi110.dll
-
isacctchange.dll - IS Account change notification
-
logread.exe - SQL Server Replication Logreader Agent
-
mergetxt.dll - SQL Server Text Merge Resolver
-
Microsoft.AnalysisServices.Graphing.DLL
-
Microsoft.DataWarehouse.DLL - Microsoft.DataWarehouse
-
Microsoft.DataWarehouse.SQM.dll - Microsoft.DataWarehouse.SQM
-
Microsoft.NetEnterpriseServers.ExceptionMessageBox.dll - ExceptionMessageBox
-
Microsoft.NetEnterpriseServers.Express.ExceptionMessageBox.dll
-
Microsoft.SqlServer.DTEnum.dll
-
Microsoft.SqlServer.DtsMsg.dll - Managed DTS Msg Poster
Behaviors exhibited
3 Services
- sqlwriter.exe runs as a service named 'Enregistreur VSS SQL Server' (SQLWriter) "Fournit l'interface permettant de sauvegarder/restaurer un serveur Microsoft SQL par le biais de l'infrastructure Windows VSS.".
- sqladhlp.exe runs as a service named 'SQL Active Directory Helper Service' (MSSQLServerADHelper100) "Enables integration with Active Directories".
- sqlbrowser.exe runs as a service named 'SQL Server Browser' (SQLBrowser) "Provides SQL Server connection information to client computers.".
Windows Firewall Allowed Program
- sqlbrowser.exe is added as a firewall exception for 'C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe'.
How do I remove SQL Server Command Line Query Tool?
You can uninstall SQL Server Command Line Query Tool from your computer by using the Add/Remove Program feature in the Window's Control Panel.
- On the Start menu (for Windows 8, right-click the screen's bottom-left corner), click Control Panel, and then, under Programs, do one of the following:
- Windows Vista/7/8/10: Click Uninstall a Program.
- Windows XP: Click Add or Remove Programs.
- When you find the program SQL Server Command Line Query Tool, click it, and then do one of the following:
- Windows Vista/7/8/10: Click Uninstall.
- Windows XP: Click the Remove or Change/Remove tab (to the right of the program).
- Follow the prompts. A progress bar shows you how long it will take to remove SQL Server Command Line Query Tool.
OS VERSIONS
Win 7 (SP1) 53%
Win 7 3%
|
|
HOW IT RUNS
Windows Service? Yes
(Installs a service)
|
|
USER ACTIONS
 |
Uninstall it 7%
Keep it 93%
|
|
Windows
Which Windows OS versions does it run on?
| Windows 7 |
56.25% |
|
| Windows XP |
21.88% |
|
| Windows 10 |
12.50% |
|
| Windows Server 2003 |
6.25% |
|
| Windows Vista |
3.13% |
|
Which OS releases does it run on? |
| Windows 7 Professional |
31.25% |
|
| Microsoft Windows XP |
21.88% |
|
| Windows 7 Enterprise |
12.50% |
|
| Windows 7 Home Premium |
9.38% |
|
| Windows Vista Home Premiu... |
3.13% |
|
| Windows 10 Pro |
3.13% |
|
Geography
65.91% of installs come from the United States
Which countries install it?
| United States |
65.91% |
| Israel |
4.55% |
| Germany |
4.55% |
| Slovenia |
2.27% |
| PS |
2.27% |
| Norway |
2.27% |
| Switzerland |
2.27% |
| Australia |
2.27% |
| Sweden |
2.27% |
| Portugal |
2.27% |
| Netherlands |
2.27% |
| DK |
2.27% |
| Canada |
2.27% |
| Italy |
2.27% |
PC manufacturers
What PC manufacturers (OEMs) have it installed?
| Dell |
34.48% |
|
| Hewlett-Packard |
27.59% |
|
| Intel |
13.79% |
|
| ASUS |
3.45% |
|
| GIGABYTE |
3.45% |
|
| Compaq |
3.45% |
|
| Medion |
3.45% |
|
| Toshiba |
3.45% |
|
| Lenovo |
3.45% |
|
| Acer |
3.45% |
|
Common models |
| Panasonic Corporation CF-... |
3.70% |
|
| MEDIONPC MS-7728 |
3.70% |
|
| Gigabyte G31M-S2L |
3.70% |
|
| Dell OptiPlex 390 |
3.70% |
|
| Dell OptiPlex 380 |
3.70% |
|
| HP Pavilion dv7 Notebook ... |
3.70% |
|
About Microsoft
Microsoft Corporation develops, manufactures, licenses and supports a variety of products and services related to computing.
Publisher URL: www.microsoft.com