Problem in executing same SQL Update stmt many times in SQL Server 6.5 
Author Message
 Problem in executing same SQL Update stmt many times in SQL Server 6.5

The SQL update statement works sometimes but fails on every 2nd or 3rd try.
When I execute the same update statement multiple times I am get this
message :

Msg 21, Level 22, State 1
WARNING - Fatal Error 7120 occurred at May  2 1997  1:52PM.  Please note
the error and time, and contact your System Administrator.
The SQL Server is terminating this process.

What is puzzling is that it works and then again it does not and then again
it does. The response is unpredictable. Would anyone know if Error 7120 a
known bug?
Any help would be greatly appreciated.



Tue, 19 Oct 1999 03:00:00 GMT
 Problem in executing same SQL Update stmt many times in SQL Server 6.5

Quote:

> The SQL update statement works sometimes but fails on every 2nd or 3rd try.
> When I execute the same update statement multiple times I am get this
> message :

> Msg 21, Level 22, State 1
> WARNING - Fatal Error 7120 occurred at May  2 1997  1:52PM.  Please note
> the error and time, and contact your System Administrator.
> The SQL Server is terminating this process.

> What is puzzling is that it works and then again it does not and then again
> it does. The response is unpredictable. Would anyone know if Error 7120 a
> known bug?

 Anil,

 First time I've heard of a 7120 - so if it's a bug, it's a new one.  Do you
have a repro script?


 Protech Computing Ltd (MS Solution Provider)
 Using Virtual Access 3.52 build 159c (32-bit) on NT 4.0 SP2



Sat, 23 Oct 1999 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. migrating sql databases sever 6.5 from sql server 6.5 to another sql server 6.5

2. SQL Server 6.5 Delete Query Time Problem

3. Update problem with VB6 and SQL Server 6.5

4. Update problem with VFP 5.0 and SQL server 6.5

5. Problem Upsizing SQL Server 6.5 to SQL Server 2000

6. Problem: Upgrading SQL Server 6.5 to SQL Server 2000

7. SQL Server 6.5 > SQL Server 7.0 problems

8. Problems connecting sql server 6.5 and sql server 7

9. Problem installing SQL Server 6.5 on the computer with SQL Server 7.0

10. Updating from SQL 6.5 trial to SQL 6.5 full

11. transfer database from one SQL Server 6.5 to another SQL Server 6.5

12. Transfer database from one SQL Server 6.5 to another SQL Server 6.5


 
Powered by phpBB® Forum Software