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
Showing posts with label netsend. Show all posts
Showing posts with label netsend. Show all posts
Wednesday, March 28, 2012
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
>
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
>
NetSend going away with 2003?
Someone from this newsgroup mentioned that Net Send was
going away with Windows 2003. Is this true? if so what are
they planning to use as a replacement? Any articles or
info would be greatly appreciated.
Thanks
FredNo, but the service is disabled by default, so you have to enable it first.
NET START Messenger
Will tell you that it is disabled
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2003 All rights reserved.
"fred" <susanbauer@.yahoo.com> wrote in message
news:051e01c35c71$8534b670$a401280a@.phx.gbl...
> Someone from this newsgroup mentioned that Net Send was
> going away with Windows 2003. Is this true? if so what are
> they planning to use as a replacement? Any articles or
> info would be greatly appreciated.
> Thanks
> Fred
>
going away with Windows 2003. Is this true? if so what are
they planning to use as a replacement? Any articles or
info would be greatly appreciated.
Thanks
FredNo, but the service is disabled by default, so you have to enable it first.
NET START Messenger
Will tell you that it is disabled
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2003 All rights reserved.
"fred" <susanbauer@.yahoo.com> wrote in message
news:051e01c35c71$8534b670$a401280a@.phx.gbl...
> Someone from this newsgroup mentioned that Net Send was
> going away with Windows 2003. Is this true? if so what are
> they planning to use as a replacement? Any articles or
> info would be greatly appreciated.
> Thanks
> Fred
>
Monday, March 26, 2012
Net Send
I got this script from Database journal and I found that very useful to DBA:
Create procedure netsend @.dbname varchar(50)
As
--Script Language and Platform: MS SQL 7.0 and MS SQL 2000
--Objecttive: Before restoreing,upgrading database,database administrator is
responsible to
--inform all the users in that database that they are going to be
disconnected and remind
--them to save their works.
--exec netsend 'xyz'--xyz is the database name
--Created by :Claire Hsu 2003/4/19
--Email:messageclaire@.yahoo.com
create table table1000(msg varchar(500))
insert into table1000
select "net send "+ltrim(rtrim(y.hostname))+ ' "we will log you out in 2 min
,please save your work"' from master.dbo.sysprocesses
y,master.dbo.sysdatabases x
where x.dbid = y.dbid and x.name = @.dbname
declare @.msgs varchar(500)
declare cur1 cursor for select msg from table1000
open cur1
fetch next from cur1 into @.msgs
while @.@.fetch_status = 0
begin
exec master.dbo.xp_cmdshell @.msgs
fetch next from cur1 into @.msgs
end
close cur1
deallocate cur1
drop table table1000
--Usage
--exec netsend 'xyz'
However when I ran this query, I got the error message as below:
Server: Msg 207, Level 16, State 3, Procedure netsend, Line 14
Invalid column name 'net send '.
I think the something wrong with the " net send", anyone can advise on this?
Thanks so muchDo not use colon, use apostrophes instead.
> select "net send "+ltrim(rtrim(y.hostname))+ ' "we will log you out in 2 min[/colo
r]
select 'net send ' + ltrim(rtrim(y.hostname)) + ' "we will log you out in 2
min
AMB
"Sql Fren" wrote:
> I got this script from Database journal and I found that very useful to DB
A:
> Create procedure netsend @.dbname varchar(50)
> As
> --Script Language and Platform: MS SQL 7.0 and MS SQL 2000
> --Objecttive: Before restoreing,upgrading database,database administrator
is
> responsible to
> --inform all the users in that database that they are going to be
> disconnected and remind
> --them to save their works.
> --exec netsend 'xyz'--xyz is the database name
> --Created by :Claire Hsu 2003/4/19
> --Email:messageclaire@.yahoo.com
>
> create table table1000(msg varchar(500))
> insert into table1000
> select "net send "+ltrim(rtrim(y.hostname))+ ' "we will log you out in 2 m
in
> ,please save your work"' from master.dbo.sysprocesses
> y,master.dbo.sysdatabases x
> where x.dbid = y.dbid and x.name = @.dbname
> declare @.msgs varchar(500)
> declare cur1 cursor for select msg from table1000
> open cur1
> fetch next from cur1 into @.msgs
> while @.@.fetch_status = 0
> begin
> exec master.dbo.xp_cmdshell @.msgs
> fetch next from cur1 into @.msgs
> end
> close cur1
> deallocate cur1
> drop table table1000
>
> --Usage
> --exec netsend 'xyz'
>
> However when I ran this query, I got the error message as below:
> Server: Msg 207, Level 16, State 3, Procedure netsend, Line 14
> Invalid column name 'net send '.
>
> I think the something wrong with the " net send", anyone can advise on thi
s?
> Thanks so much
>|||Correction,
Do not use quotation mark, use apostrophes instead.
> select "net send "+ltrim(rtrim(y.hostname))+ ' "we will log you out in 2 min[/colo
r]
select 'net send ' + ltrim(rtrim(y.hostname)) + ' "we will log you out in 2
min
AMB
"Alejandro Mesa" wrote:
> Do not use colon, use apostrophes instead.
>
> select 'net send ' + ltrim(rtrim(y.hostname)) + ' "we will log you out in
2
> min
>
> AMB
> "Sql Fren" wrote:
>
Create procedure netsend @.dbname varchar(50)
As
--Script Language and Platform: MS SQL 7.0 and MS SQL 2000
--Objecttive: Before restoreing,upgrading database,database administrator is
responsible to
--inform all the users in that database that they are going to be
disconnected and remind
--them to save their works.
--exec netsend 'xyz'--xyz is the database name
--Created by :Claire Hsu 2003/4/19
--Email:messageclaire@.yahoo.com
create table table1000(msg varchar(500))
insert into table1000
select "net send "+ltrim(rtrim(y.hostname))+ ' "we will log you out in 2 min
,please save your work"' from master.dbo.sysprocesses
y,master.dbo.sysdatabases x
where x.dbid = y.dbid and x.name = @.dbname
declare @.msgs varchar(500)
declare cur1 cursor for select msg from table1000
open cur1
fetch next from cur1 into @.msgs
while @.@.fetch_status = 0
begin
exec master.dbo.xp_cmdshell @.msgs
fetch next from cur1 into @.msgs
end
close cur1
deallocate cur1
drop table table1000
--Usage
--exec netsend 'xyz'
However when I ran this query, I got the error message as below:
Server: Msg 207, Level 16, State 3, Procedure netsend, Line 14
Invalid column name 'net send '.
I think the something wrong with the " net send", anyone can advise on this?
Thanks so muchDo not use colon, use apostrophes instead.
> select "net send "+ltrim(rtrim(y.hostname))+ ' "we will log you out in 2 min[/colo
r]
select 'net send ' + ltrim(rtrim(y.hostname)) + ' "we will log you out in 2
min
AMB
"Sql Fren" wrote:
> I got this script from Database journal and I found that very useful to DB
A:
> Create procedure netsend @.dbname varchar(50)
> As
> --Script Language and Platform: MS SQL 7.0 and MS SQL 2000
> --Objecttive: Before restoreing,upgrading database,database administrator
is
> responsible to
> --inform all the users in that database that they are going to be
> disconnected and remind
> --them to save their works.
> --exec netsend 'xyz'--xyz is the database name
> --Created by :Claire Hsu 2003/4/19
> --Email:messageclaire@.yahoo.com
>
> create table table1000(msg varchar(500))
> insert into table1000
> select "net send "+ltrim(rtrim(y.hostname))+ ' "we will log you out in 2 m
in
> ,please save your work"' from master.dbo.sysprocesses
> y,master.dbo.sysdatabases x
> where x.dbid = y.dbid and x.name = @.dbname
> declare @.msgs varchar(500)
> declare cur1 cursor for select msg from table1000
> open cur1
> fetch next from cur1 into @.msgs
> while @.@.fetch_status = 0
> begin
> exec master.dbo.xp_cmdshell @.msgs
> fetch next from cur1 into @.msgs
> end
> close cur1
> deallocate cur1
> drop table table1000
>
> --Usage
> --exec netsend 'xyz'
>
> However when I ran this query, I got the error message as below:
> Server: Msg 207, Level 16, State 3, Procedure netsend, Line 14
> Invalid column name 'net send '.
>
> I think the something wrong with the " net send", anyone can advise on thi
s?
> Thanks so much
>|||Correction,
Do not use quotation mark, use apostrophes instead.
> select "net send "+ltrim(rtrim(y.hostname))+ ' "we will log you out in 2 min[/colo
r]
select 'net send ' + ltrim(rtrim(y.hostname)) + ' "we will log you out in 2
min
AMB
"Alejandro Mesa" wrote:
> Do not use colon, use apostrophes instead.
>
> select 'net send ' + ltrim(rtrim(y.hostname)) + ' "we will log you out in
2
> min
>
> AMB
> "Sql Fren" wrote:
>
Subscribe to:
Posts (Atom)