Network I/O error in SQL 2000 with SP4 ?

Can anyone explain this NETWORK I/O error I received using SP4, SQL 2K.
"spid85 Process ID 90 killed by hostname tester, host process ID 23328"It would seem that a user by the name of "tester" issued a KILL command for
your connection. Virtual homicide? Nah... Look up KILL in Books Online.
ML
http://milambda.blogspot.com/sql

Network

We are developing with SQL 7 Developer Edition and planning to install
MSDE with the VB application. We received the following question from
the IT dept. of our client:
"Does your version of SQLServer database work well across a frame
relay wide area network?"
Should there be any problems regarding speed, etc.?
Thanks!
Ernie Adsett"Ernie Adsett" <ernie@.amt.nb.ca> wrote in message
news:JhAPb.69757$IF6.1700023@.ursa-nb00s0.nbnet.nb.ca...

quote:

---

> We are developing with SQL 7 Developer Edition and planning to install
> MSDE with the VB application. We received the following question from
> the IT dept. of our client:
> "Does your version of SQLServer database work well across a frame
> relay wide area network?"
> Should there be any problems regarding speed, etc.?
> Thanks!
> Ernie Adsett
>

---

If your application is written to avoid unnecessary network traffic (use
stored procedures, avoid returning unnecessary rows in result sets etc.),
then there shouldn't be any special considerations. But to get a definite
answer, you would need to test it, of course.
Simon|||"Ernie Adsett" <ernie@.amt.nb.ca> wrote in message
news:JhAPb.69757$IF6.1700023@.ursa-nb00s0.nbnet.nb.ca...

quote:

---

> We are developing with SQL 7 Developer Edition and planning to install
> MSDE with the VB application. We received the following question from
> the IT dept. of our client:
> "Does your version of SQLServer database work well across a frame
> relay wide area network?"
> Should there be any problems regarding speed, etc.?

---

Depends entirely on your design and how good it is.

quote:

---

> Thanks!
> Ernie Adsett
>

---

sql

Network

We are developing with SQL 7 Developer Edition and planning to install
MSDE with the VB application. We received the following question from
the IT dept. of our client:
"Does your version of SQLServer database work well across a frame
relay wide area network?"
Should there be any problems regarding speed, etc.?

Thanks!

Ernie Adsett"Ernie Adsett" <ernie@.amt.nb.ca> wrote in message
news:JhAPb.69757$IF6.1700023@.ursa-nb00s0.nbnet.nb.ca...
> We are developing with SQL 7 Developer Edition and planning to install
> MSDE with the VB application. We received the following question from
> the IT dept. of our client:
> "Does your version of SQLServer database work well across a frame
> relay wide area network?"
> Should there be any problems regarding speed, etc.?
> Thanks!
> Ernie Adsett

If your application is written to avoid unnecessary network traffic (use
stored procedures, avoid returning unnecessary rows in result sets etc.),
then there shouldn't be any special considerations. But to get a definite
answer, you would need to test it, of course.

Simon|||"Ernie Adsett" <ernie@.amt.nb.ca> wrote in message
news:JhAPb.69757$IF6.1700023@.ursa-nb00s0.nbnet.nb.ca...
> We are developing with SQL 7 Developer Edition and planning to install
> MSDE with the VB application. We received the following question from
> the IT dept. of our client:
> "Does your version of SQLServer database work well across a frame
> relay wide area network?"
> Should there be any problems regarding speed, etc.?

Depends entirely on your design and how good it is.

> Thanks!
> Ernie Adsett

NetSend notifications

I received the error message listed below after stopping and restarting my
SQL Server 2005 database server.
Please help me resolve this error.
Thank You,
Errorlog Error Message:
[364] The Messenger service has not been started - NetSend notifications
will not be sent
Joe K. wrote:
> I received the error message listed below after stopping and restarting my
> SQL Server 2005 database server.
> Please help me resolve this error.
> Thank You,
>
> Errorlog Error Message:
> [364] The Messenger service has not been started - NetSend notifications
> will not be sent
>
Has the Messenger service been started?
Tracy McKibben
MCDBA
http://www.realsqlguy.com
|||Why would you even consider starting the Messenger service on a Server?
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:456F40A5.3040400@.realsqlguy.com...
> Joe K. wrote:
> Has the Messenger service been started?
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
sql

NetSend notifications

I received the error message listed below after stopping and restarting my
SQL Server 2005 database server.
Please help me resolve this error.
Thank You,
Errorlog Error Message:
[364] The Messenger service has not been started - NetSend notifications
will not be sentJoe K. wrote:
> I received the error message listed below after stopping and restarting my
> SQL Server 2005 database server.
> Please help me resolve this error.
> Thank You,
>
> Errorlog Error Message:
> [364] The Messenger service has not been started - NetSend notificatio
ns
> will not be sent
>
Has the Messenger service been started?
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Why would you even consider starting the Messenger service on a Server?
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:456F40A5.3040400@.realsqlguy.com...
> Joe K. wrote:
> Has the Messenger service been started?
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||Arnie Rowland wrote:
> Why would you even consider starting the Messenger service on a Server?
>
Hey, I was just asking the obvious question based on the error
message... :-)
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||My response was not directed at you Tracy, I expect that you know better...
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:456F4A0E.7040100@.realsqlguy.com...
> Arnie Rowland wrote:
> Hey, I was just asking the obvious question based on the error message...
> :-)
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||Agent has an option to alert an operator through NET SEND, which uses the Me
ssenger service. If the
service isn't started, then Agent will write this entry to the eventlog. The
messenger and Alerter
(used on the client which receives the message) is considered security risky
and are both disabled
with XP sp2. If you don't Alert operators though NET SEND you can ignore thi
s entry.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Joe K." <JoeK@.discussions.microsoft.com> wrote in message
news:A5124E41-B6AC-4A8F-8C8F-CFB93F4568F8@.microsoft.com...
> I received the error message listed below after stopping and restarting my
> SQL Server 2005 database server.
> Please help me resolve this error.
> Thank You,
>
> Errorlog Error Message:
> [364] The Messenger service has not been started - NetSend notificatio
ns
> will not be sent
>