Connection broken on localhost

Following error occurs when I execute stored procedure sp_updatestats to update
statistics:
...
Updating dbo.AttachmentFolderDefinition
Updating dbo.Branch
...
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionRead
(WrapperRead()). Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
Connection Broken
I am running the procedure from the SQL Query Analyzer locally from the server.
Sometimes the same error occurs when I do a backup or when I run other stored
procedures.
The SQL Server log and Event Log didn't help.
Any ideas ?
Thanks
Radek
Radek,
You are probably running into this issue:
FIX: General network error when you try to back up or restore a SQL
Server database on a computer that is running Windows Server 2003
http://support.microsoft.com/?id=827452
Try using TCP/IP as your network library instead of Named Pipes.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Radek Pospisil wrote:
> Following error occurs when I execute stored procedure sp_updatestats to update
> statistics:
> ...
> Updating dbo.AttachmentFolderDefinition
> Updating dbo.Branch
> ...
> [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionRead
> (WrapperRead()). Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation.
> Connection Broken
>
> I am running the procedure from the SQL Query Analyzer locally from the server.
> Sometimes the same error occurs when I do a backup or when I run other stored
> procedures.
> The SQL Server log and Event Log didn't help.
> Any ideas ?
> Thanks
> Radek
|||You are right. Thanks a lot.
Radek
Mark Allison <marka@.no.tinned.meat.mvps.org> wrote in
news:OdUmcoc4EHA.4092@.TK2MSFTNGP14.phx.gbl:

> Radek,
> You are probably running into this issue:
> FIX: General network error when you try to back up or restore a SQL
> Server database on a computer that is running Windows Server 2003
> http://support.microsoft.com/?id=827452
> Try using TCP/IP as your network library instead of Named Pipes.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>

Connection Broken

I am updating records in my database with the procedure below. The data is
updated as it should but the Enterprise Manager (SQL Query Analyzer) gives
the error:
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionCheckForData
(CheckforData()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
Connection Broken
It looks like this error is blocking the SQL Server from responding to new
requests immediately (3-4 seconds) after an update.
Any ideas of what can cause this problem?
The sql call with belonging SQL procedure (below) has been tested on several
SQL servers and is working OK, but on this server I am running it against at
the moment it gives error above.
p_kontaktpersoner_endre 44, 'Tor Inge', 'Rislaa', 'TIR', 840, 'IT Manager',
'Adm', '38 15 44 30', '38 15 44 35', '900 90 700', 'myemail@.vef.no', '', 1,
'Test note', 1
CREATE PROCEDURE p_kontaktpersoner_endre
@.kp_id int = 1 ,
@.fornavn varchar(50) = '' ,
@.etternavn varchar(50) = '' ,
@.initialer varchar(3) = '' ,
@.ko_id int = 0 ,
@.stilling varchar(50) = '' ,
@.avdeling varchar(50) = '' ,
@.telefon varchar(30) = '' ,
@.telefaks varchar(30) = '' ,
@.mobiltelefon varchar(30) = '' ,
@.e_post varchar(50) = '' ,
@.kategori varchar(100) = '' ,
@.prioritet int = 1 ,
@.merknad text = '' ,
@.aktiv int = 1
AS
UPDATE kontaktpersoner
SET fornavn = @.fornavn,
etternavn = @.etternavn,
initialer = @.initialer,
ko_id = @.ko_id,
stilling = @.stilling,
avdeling = @.avdeling,
telefon = @.telefon,
telefaks = @.telefaks,
mobiltelefon = @.mobiltelefon,
e_post= @.e_post,
kategori = @.kategori,
prioritet = @.prioritet,
merknad = @.merknad,
aktiv= @.aktiv
FROM kontaktpersoner
WHERE kp_id = @.kp_idHi
You don't give the version information for SQL Server, but this may be one
cause!
http://support.microsoft.com/defaul...kb;en-us;903742
John
"Tor Inge Rislaa" <tor.ingenospam@.rislaa.no> wrote in message
news:OWme0eT3FHA.636@.TK2MSFTNGP10.phx.gbl...
>I am updating records in my database with the procedure below. The data is
>updated as it should but the Enterprise Manager (SQL Query Analyzer) gives
>the error:
>
> [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionCheckForData
> (CheckforData()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation.
> Connection Broken
>
> It looks like this error is blocking the SQL Server from responding to new
> requests immediately (3-4 seconds) after an update.
>
> Any ideas of what can cause this problem?
>
> The sql call with belonging SQL procedure (below) has been tested on
> several SQL servers and is working OK, but on this server I am running it
> against at the moment it gives error above.
>
>
> p_kontaktpersoner_endre 44, 'Tor Inge', 'Rislaa', 'TIR', 840, 'IT
> Manager', 'Adm', '38 15 44 30', '38 15 44 35', '900 90 700',
> 'myemail@.vef.no', '', 1, 'Test note', 1
> CREATE PROCEDURE p_kontaktpersoner_endre
> @.kp_id int = 1 ,
> @.fornavn varchar(50) = '' ,
> @.etternavn varchar(50) = '' ,
> @.initialer varchar(3) = '' ,
> @.ko_id int = 0 ,
> @.stilling varchar(50) = '' ,
> @.avdeling varchar(50) = '' ,
> @.telefon varchar(30) = '' ,
> @.telefaks varchar(30) = '' ,
> @.mobiltelefon varchar(30) = '' ,
> @.e_post varchar(50) = '' ,
> @.kategori varchar(100) = '' ,
> @.prioritet int = 1 ,
> @.merknad text = '' ,
> @.aktiv int = 1
> AS
> UPDATE kontaktpersoner
> SET fornavn = @.fornavn,
> etternavn = @.etternavn,
> initialer = @.initialer,
> ko_id = @.ko_id,
> stilling = @.stilling,
> avdeling = @.avdeling,
> telefon = @.telefon,
> telefaks = @.telefaks,
> mobiltelefon = @.mobiltelefon,
> e_post= @.e_post,
> kategori = @.kategori,
> prioritet = @.prioritet,
> merknad = @.merknad,
> aktiv= @.aktiv
> FROM kontaktpersoner
> WHERE kp_id = @.kp_id
>|||Thanks. Do you know where to find what version or SP my server has
TIRislaa
"John Bell" <jbellnewsposts@.hotmail.com> skrev i melding
news:%23m$JfcU3FHA.2196@.tk2msftngp13.phx.gbl...
> Hi
> You don't give the version information for SQL Server, but this may be one
> cause!
> http://support.microsoft.com/defaul...kb;en-us;903742
> John
> "Tor Inge Rislaa" <tor.ingenospam@.rislaa.no> wrote in message
> news:OWme0eT3FHA.636@.TK2MSFTNGP10.phx.gbl...
>|||Hi
Try http://www.aspfaq.com/show.asp?id=2160 and
http://www.aspfaq.com/sql2000builds.asp
In your update statement you don't need the from clause as it is the
same table as the one being updated.
John
Tor Inge Rislaa wrote:
> Thanks. Do you know where to find what version or SP my server has
> TIRislaa
> "John Bell" <jbellnewsposts@.hotmail.com> skrev i melding
> news:%23m$JfcU3FHA.2196@.tk2msftngp13.phx.gbl...