broken connection - SQL Server Forums

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)

broken connection

Author

Topic

wawansur
Starting Member

44 Posts

Posted - 2009-08-13 : 05:30:06

i run this query in the other PC from my PC in the Query Analyzer.

ALTER VIEW dbo.vNeraca
--WITH ENCRYPTION
AS

Select AA.FBln,AA.FThn,AA.FCOA,ATy.FType,
IsNull((Select Sum(FNominal) from J_R Where FCOA In(SELECT FCOA FROM COA C
INNER JOIN AType A ON C.FType = A.FType WHERE A.FOrder >= 4000 AND
A.FOrder < 9000 And Month(FTgl)=AA.FBln And Year(Ftgl)=AA.FThn)),0) As FNominal
From ALR AA
INNER JOIN COA C ON C.FCOA=AA.FCOA
INNER JOIN ATYPE ATy ON ATy.FType=C.FType

i have result like this

Server: Msg 644, Level 21, State 3, Procedure vNeraca, Line 10
Could not find the index entry for RID '16072cfd1bfed272131000500' in index page (1:152), index ID 0, database 'dbIntegrated_BNI_WOEn'.
ODBC: Msg 0, Level 16, State 1
Communication link failure
ODBC: Msg 0, Level 16, State 1
Communication link failure

Connection Broken

Any suggest ?

Rgds

wawansur
Starting Member

44 Posts

Posted - 2009-08-13 : 22:47:38

As information, this happen after i defragment the PC.
That error is happen when i run qeury only.
I can do the other task, like backup,restore,attach and detach the database.

Rgds

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2009-08-14 : 00:42:34

double post. http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=131174

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources