The compatbility level of database is lvl 80
and the format of format file (i guess) is ASCII
p.s. what is compatbility level of a database?
i encoutered the same error and it's strange the problem solved if i put the records (the rows cause errors) to the end of the file.
the sql 2000...
i modified the sql statement and it now run a lot faster.
the part i mod are:
FROM dbo.AgPayDtl LEFT OUTER JOIN...
I run the sp_updatestats and the WITH RECOMPILE methods and added 2 other indexs, while the performance is a little bit faster. it is still a lot...
i'll take a look on the article. thx a lot for your help
I am running a web app which the web page pass the parameters to the sp and return the recordset to display.
Separate names with a comma.