SQL Server Tools default Location


SQL Server Tools default Location

SQL Server工具預設位置


 

Tools SQL Server versions Location
sqlcmd.exe, bcp.exe SQL 2008 R2 C:\Program Files\Microsoft SQL Server\100\Tools\Binn\
SQL 2012 C:\Program Files\Microsoft SQL Server\110\Tools\Binn\
SQL 2014 C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn\
SQL 2016 C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn\
Integration Services component
dtexec.exe
SQL 2008 R2 C:\Program Files\Microsoft SQL Server\100\ DTS\Binn\
C:\Program Files(x86)\Microsoft SQL Server\100\DTS\Binn\
SQL 2012 C:\Program Files\Microsoft SQL Server\110\ DTS\Binn\
C:\Program Files(x86)\Microsoft SQL Server\110\DTS\Binn\

 

Reference:

File Locations for Default and Named Instances of SQL Server
https://docs.microsoft.com/en-us/sql/sql-server/install/file-locations-for-default-and-named-instances-of-sql-server
dtexec Utility
https://docs.microsoft.com/en-us/sql/integration-services/packages/dtexec-utility

Comments (0)

Skip to main content