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 |
|
balajionnet
Starting Member
5 Posts |
 Posted - 2009-05-09 : 14:04:09
|
| HI I'm Using VB6.0 and SQL Server 2000 on Network. When I Execute INSERT Statement from code it executes successfully but Occasionally it fails to insert data on a particular TABLE. This Problem Occurs even when I execute code from the SERVER system. (Even I used Stored Procedure, But same problem) But When the program is executed in standalone system(Without NETWORK) there no problem found. I was much confused with this problem..... Help me.. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-05-09 : 14:13:39
|
| did you check if the table has any insert triggers defined on it? |
 |
|
|
balajionnet
Starting Member
5 Posts |
Posted - 2009-05-10 : 03:17:48
|
| No.... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-05-10 : 03:28:31
|
quote:
Originally posted by balajionnet
No....
did you mean you didnt check or no triggers present? |
|
|
|
balajionnet
Starting Member
5 Posts |
Posted - 2009-05-16 : 01:07:40
|
| No Trigger I'd Created...Since I'm Beginer i Dont know how to solve or debug this problem |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-05-16 : 03:44:18
|
| ok...but did you check whether there was anything existing? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Occasionally DATA not Inserting