Search code examples
sql-serversql-server-2008t-sqlsql-server-2012bcp

Data export from BCP

Changing from SQL Server Management Studio 2008 to 2012 has resulted in my cmd code not working :

bcp "SELECT  [id],[AlmLog_TimeStamp],[AlmLog_ID],[AlmLog_State] 
FROM DB02REA05461.[dbo].[AlarmLog] 
ORDER BY [id]" 
queryout wtg02.txt -c -S10.51.23.51\NAID -Ucus -PsFO

It gives me the following error:

SQLState = 08001, NativeError = 22 Error = [Microsoft][SQL Server Native Client 11.0]SQL Server Native Client 11.0 does not support connections to SQL Server 2000 or earlier versions. SQLState = 08001, NativeError = 22 Error = [Microsoft][SQL Server Native Client 11.0]Client unable to establish connection

Any help on altering the code from cmd would be appreciated.

Solution

  • The command line tools provided by SSMS 2012 are not compatible with SQL Server 2000. You will need to either upgrade your SQL Server 2000, or downgrade your SSMS back to 2008.