Warning: Fatal error 823 occurred

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.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Warning: Fatal error 823 occurred

Author

Topic

askcomputer
Starting Member

12 Posts

Posted - 2006-05-15 : 07:40:59

I run one query, this query give the error as below error details

Server: Msg 21, Level 24, State 1, Line 1
Warning: Fatal error 823 occurred at May 15 2006 4:13AM

Connection Broken

Please give the details / solution about this error.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-05-15 : 08:23:19

Yes, I can help you if you help me with some minor details, such as

1. Where did this error occur?
2. What syntax does your query have?
3. Is it against local server or a linked server?

askcomputer
Starting Member

12 Posts

Posted - 2006-05-15 : 08:27:04

1. Where did this error occur?

under where condition

2. What syntax does your query have?
select
from
where
(( ) or ())
and
(not exit select statement)

3. Is it against local server or a linked server?

linked server

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-05-15 : 10:18:42

Then the most possible reason for the error is that

1. The linked server database is stopped.
2. The linked server database is occupied with other stuff (reindexing, backup).
3. The linked server is down (power off).
4. The linked server is busy with other stuff (defragmenting).
5. A cable to the linked server is dropped (replug all cables).
6. A router/switch/hub is faulty or not working.
7. Too much data is passed on the network.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources