asked on

isql Unexpected EOF from SQL server

Hi experts!

I'm running following command:
isql /Q "exec mydb.dbo.myProc" /d mydb /E /p /r /S servername

throws following error:

Unexpected EOF from SQL Server. General network error. Check your documentation.
Net-Library error 10054: ConnectionCheckForData (CheckforData()).
DB-Library: DBPROCESS is dead or not enabled.
DB-Library: DBPROCESS is dead or not enabled.
DB-Library: DBPROCESS is dead or not enabled.
DB-Library: DBPROCESS is dead or not enabled.

The stored procedure only executes inserts.
Did anyone encounter such problem? Do you know what can be causing this?

ASKER CERTIFIED SOLUTION

Sirees

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

EugeneZ

check your 'servername' - what sql server Service pack (also post version\edition )do you have?

Also on the sql server check sql server 'Server Network Utility'
to see what network protocols are enabled...

Post result

EugeneZ

try to run
DBCC CHECKDB for your 'mydb' database

also try to user osql instead of the isql..

EugeneZ

if DBCC CHECKDB will show you problems
use DBCC DBREINDEX

DBCC CHECKDB
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_dbcc_00gy.asp

DBCC DBREINDEX
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_dbcc_94mw.asp

VovinE

ASKER

It seems that transaction log was full.

EugeneZ

if "It seems that transaction log was full" you will see sql errors log - alerts
otherwice - DBCC DBREindex or maybe in your case you had Sql server maint optimization plan running.