CODEWITHSUNDEEP
sqlsql-server
user3087972
user3087972

Reputation: 1

sqlcmd: Native Client 11.0 does not support connections to SQL Server 2000

I'm trying to execute an SQL script using the sqlcmd utility, but it uses the SQL Server Native Client 11.0 and returns the error in the title. In Management Studio, I can connect to the database engine using the Client version 10.0. Is there any way to use version 10.0 using sqlcmd?

Upvotes: 0

Views: 5003

Answers (1)

Aaron Bertrand
Aaron Bertrand

Reputation: 280431

Sure, you should have a version 10.0 copy of sqlcmd in the following path:

C:\Program Files\Microsoft SQL Server\100\Tools\Binn\SQLCMD.exe

(If you don't, then download a version of 2008 Express with Tools and install just the client tools.)

Just call that directly instead of the default one with no path (which will usually default to the most recent version).

Upvotes: 1

Related Questions