sqlcmd output incomplete solution

Little scum · Posted on 3/26/2020 4:39:40 PM

Found the problem. There are several versions of SQLCMD installed on the machine. Find out which version I use:

E:\Test>where sqlcmd
C:\Program Files\Microsoft SQL Server\100\Tools\Binn\SQLCMD.EXE
C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn\SQLCMD.EXE

I'm using SQL Server 2008 R2 version. I investigated the system environment variable PATH and changed the order, and now it uses SQL Server 2012 version. After changing the path

E:\Test>where sqlcmd
C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn\SQLCMD.EXE
C:\Program Files\Microsoft SQL Server\100\Tools\Binn\SQLCMD.EXE

E:\Test>sqlcmd -S testserver -dTestdb -i StackOverflowSQL.sql

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)
Script Completed With Success - Changes committed on Nov 29 2017 3:37PM

Little scum · Posted on 6/1/2023 7:00:45 PM

(MSSQL) SQL SERVER executes very large SQL scripts
https://www.itsvse.com/thread-10600-1-1.html

[Source] sqlcmd output incomplete solution

Related Posts