Running a stored procedure in SQL 2000

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

SQL Server Administration (2000)

Running a stored procedure in SQL 2000

Author

Topic

jdoering
Starting Member

32 Posts

Posted - 2002-09-16 : 10:09:50

The stored procedure runs fine on the local server machine however it does run correctly on client query analyzers. I have set NOCOUNT ON.
I receive the following error:

[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 suggestions would be greatly appreciated.

Thanks,

chadmat
The Chadinator

1974 Posts

Posted - 2002-09-16 : 12:47:03

What does:
select @@servername

return?

-Chad

cschlup
Starting Member

1 Post

Posted - 2003-12-03 : 08:48:24

I also am getting the same error as Jdoering and would like to know if there is a solution to this issue.

Thanks
Caroline

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-12-03 : 12:17:59

This is a communication problem to the database server. DBNETLIB indicates that you are using named pipes. Try TCP/IP instead. You can do this with the Client Network Utility tool by setting up an alias.

Tara

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources