Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-06-16 : 09:10:33
|
Alex writes "Hi All,
I use Sql Server 2000 as my backend for a Delphi - 5 application . I also use Midas technology. Normally I create a database,import some data in to it and test my product. The database size is about 100 mb
After testing for some time I get an error
"INSERT FAILED DUE TO INCORRECT SET OPTIONS FOR ANSI_PADDING,ANSI_NULL,ARITH_IGNORE......"
Once I get this error I again get this error more frequently in many forms.
What is even more puzzling is that I have 2 installations of Sql Server 2000 Server.
I get this error more frequently in one server while in the other server does not give me this error as frequently. I tried reinstalling the SQL SERVER on one server , but this has not worked.
One Opinion that has come up during our brain storming is that in all cases a paritcular table may be the culprit . I don't have any proof of this though. If you also think so what could be wrong
Please provide some help in this regard
Thanx in advance
Alex" |
|
|
|
|
|
ANSI_paddings,ANSI_Null Set options error