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...

Connection Breaks on StProc text UPDATE

Hi,
We have a simple stored procedure that has a text parameter, among others.
Inside the procedure the text parameter is assigned to a text column in a
simple SET clause of a simple UPDATE statement. We pass a 15 character
string as an argument for the parameter, and even though the string is
stored to the table, we get this error message (running in Query
Analyzer)...
*-*-*-*
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData
(CheckforData()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
Connection Broken
*-*-*-*
Any of the following make the error message go away...
1) Pass NULL as the argument
2) Comment out the assignment in the SET clause
3) Change the parameter to varchar(8000)
Anyone have any ideas?
--
Thank you,
Daniel Jameson
Children's Oncology Group
http://www.childrensoncologygroup.orgCan you show the CREATE TABLE statement and the CREATE PROCEDURE code?
Also, tell us the result of SELECT @.@.VERSION
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"danjam" <djameson@.childrensoncologygroup.org> wrote in message
news:e6y2#eMxDHA.3416@.tk2msftngp13.phx.gbl...
> Hi,
> We have a simple stored procedure that has a text parameter, among others.
> Inside the procedure the text parameter is assigned to a text column in a
> simple SET clause of a simple UPDATE statement. We pass a 15 character
> string as an argument for the parameter, and even though the string is
> stored to the table, we get this error message (running in Query
> Analyzer)...
> *-*-*-*
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData
> (CheckforData()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation.
> Connection Broken
> *-*-*-*
> Any of the following make the error message go away...
> 1) Pass NULL as the argument
> 2) Comment out the assignment in the SET clause
> 3) Change the parameter to varchar(8000)
> Anyone have any ideas?
> --
> Thank you,
> Daniel Jameson
> Children's Oncology Group
> http://www.childrensoncologygroup.org
>|||There are some known bugs that cause this or similar errors - it would
help to see your stored procedure. It could be an issue with UNION,
with an INSTEAD OF trigger, certain query structures, or an unknown
bug... It does sound like a bug, though.
SK
danjam wrote:
>Hi,
>We have a simple stored procedure that has a text parameter, among others.
>Inside the procedure the text parameter is assigned to a text column in a
>simple SET clause of a simple UPDATE statement. We pass a 15 character
>string as an argument for the parameter, and even though the string is
>stored to the table, we get this error message (running in Query
>Analyzer)...
>*-*-*-*
>[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData
>(CheckforData()).
>Server: Msg 11, Level 16, State 1, Line 0
>General network error. Check your network documentation.
>Connection Broken
>*-*-*-*
>Any of the following make the error message go away...
> 1) Pass NULL as the argument
> 2) Comment out the assignment in the SET clause
> 3) Change the parameter to varchar(8000)
>Anyone have any ideas?
>
>|||Steve,
Thank you for responding. I have posted additional info under Aaron's post.
I do have an INSTEAD of trigger, but there are no UNION's involved.
--
Thank you,
Daniel Jameson
Children's Oncology Group
http://www.childrensoncologygroup.org
"Steve Kass" <skass@.drew.edu> wrote in message
news:uIFJ5pMxDHA.2556@.TK2MSFTNGP10.phx.gbl...
> There are some known bugs that cause this or similar errors - it would
> help to see your stored procedure. It could be an issue with UNION,
> with an INSTEAD OF trigger, certain query structures, or an unknown
> bug... It does sound like a bug, though.
> SK
> danjam wrote:
> >Hi,
> >
> >We have a simple stored procedure that has a text parameter, among
others.
> >Inside the procedure the text parameter is assigned to a text column in a
> >simple SET clause of a simple UPDATE statement. We pass a 15 character
> >string as an argument for the parameter, and even though the string is
> >stored to the table, we get this error message (running in Query
> >Analyzer)...
> >
> >*-*-*-*
> >[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData
> >(CheckforData()).
> >Server: Msg 11, Level 16, State 1, Line 0
> >General network error. Check your network documentation.
> >
> >Connection Broken
> >*-*-*-*
> >
> >Any of the following make the error message go away...
> > 1) Pass NULL as the argument
> > 2) Comment out the assignment in the SET clause
> > 3) Change the parameter to varchar(8000)
> >
> >Anyone have any ideas?
> >
> >
> >
>