参考:用sql 2008恢复sql 2000的备份文件将sql server 2008的兼容级别设置为80,然后再恢复sql server 2000的备份文件. 更改方式如下: Microsoft SQL Server Management Studio->ServerName->Database->database name ,right manu->properties->options->Campatiblity level->downframe list,select: sql sever 2000 (80)-> Click buton ok 恢复完毕后,再改为90.
语句: TRUNCATE TABLE A BULK INSERT A FROM 'D:\test.txt' WITH( CODEPAGE='RAW', FIRSTROW=2 )SQL 2008下的错误: Msg 7339, Level 16, State 1, Line 1 OLE DB provider 'BULK' for linked server '(null)' returned invalid data for column '[BULK].PartnerNumber'. 说明:比较过表结构,且是同一文件
Microsoft SQL Server Management Studio->ServerName->Database->database name ,right manu->properties->options->Campatiblity level->downframe list,select: sql sever 2000 (80)-> Click buton ok 恢复完毕后,再改为90.
TRUNCATE TABLE A
BULK INSERT A FROM 'D:\test.txt'
WITH( CODEPAGE='RAW', FIRSTROW=2 )SQL 2008下的错误:
Msg 7339, Level 16, State 1, Line 1
OLE DB provider 'BULK' for linked server '(null)' returned invalid data for column '[BULK].PartnerNumber'.
说明:比较过表结构,且是同一文件
什么的驱动? SQL 2008?