Help: SQL Error: Msg 7134, Level 16, State 2 
Author Message
 Help: SQL Error: Msg 7134, Level 16, State 2

I am getting the above error message while attempting to execute a Delete
Query.  I believe the syntax is correct; the Error message description in
the online book is rather obtuse.  I am wondering if someone could tell me
if it is a syntax problem or a problem with the data itself.  Here's the
Delete

DELETE FROM QUEUE
WHERE      (TRANSTO = 'ANYONE')

Thanks in advance,

-Matt



Sat, 25 Nov 2000 03:00:00 GMT
 Help: SQL Error: Msg 7134, Level 16, State 2

Matt,

 Sounds like a corruption problem.  Do a checktable and a textalloc
(dbcc commands) on the table(s) in question.

 Neil Pike MVP/MCSE
 Protech Computing Ltd



Sat, 25 Nov 2000 03:00:00 GMT
 Help: SQL Error: Msg 7134, Level 16, State 2

I believe the syntax should be

DELETE QUEUE
WHERE      (TRANSTO = 'ANYONE')

no 'FROM'.  That's SQL-92 standard syntax.



Mon, 27 Nov 2000 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. HELP - SQL Server 7.0 Error - Msg 542, Level 16, State 1

2. Help.Error: Msg 7399, Level 16, State 1, Line 1

3. SQLServer Msg 2506, Level 16, State 3 Error - Help Needed

4. Msg 5159, Level 16, State 1 OS Error 38

5. Error Message: Server: Msg 7392, Level 16, State 2

6. Error: Server: MSG 7392, Level 16, State 2

7. Msg 5159, Level 16, State 1 OS Error 38

8. Server: Msg 7399, Level 16, State 1, Line 1 error on .mdb as linked server

9. Error Msg: 7343, Level 16, State 4 (linking Database)

10. Getting Error Msg 7343, Level 16, State 4


 
Powered by phpBB® Forum Software