SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Warning: Fatal error 823 occurred		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

askcomputer
Starting Member

India
12 Posts
Posted - 05/15/2006 :  07:40:59  Show Profile  Reply with Quote
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

Sweden
29138 Posts
Posted - 05/15/2006 :  08:23:19  Show Profile  Visit SwePeso's Homepage  Reply with Quote
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?
Go to Top of Page

askcomputer
Starting Member

India
12 Posts
Posted - 05/15/2006 :  08:27:04  Show Profile  Reply with Quote
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
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
29138 Posts
Posted - 05/15/2006 :  10:18:42  Show Profile  Visit SwePeso's Homepage  Reply with Quote
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.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000