send net send messages from SQL Server 2008

I have trigger on new row insert which send net send message to client computers. It was working perfect on SQL Server 2000, now we migrate to SQL Server 2008 and my trigger is not working at all I cant send net send messages from SQL Server 2008. Is there any way that I can have messaging like on SQL 2000. I am using Windows Server 2008 32-bit, client computers have WinXP and Win7 OS.

Thanks
LVL 1
kahvedzicAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
oBdAConnect With a Mentor Commented:
You can use msg.exe to send messages to XP as well, provided you allow remote RPC on the clients as described here:
Allowing Remote RPC
http://technet.microsoft.com/en-us/library/ff710472(WS.10).aspx
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
net send has been replaced, meanwhile, by msg
http://technet.microsoft.com/en-us/library/cc771903%28WS.10%29.aspx
0
 
kahvedzicAuthor Commented:
I know that but problem is that I cant send messages to WinXP clients with msg.exe
0
Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
then, you have no choice but use some third-party lan messaging tool, which you will need to install on all the required computers (via group policy, for example)
0
 
kahvedzicAuthor Commented:
OK get that but I cant find any LAN messagin tool that support SQL server, and besides that I dont know how to use it in trigger.Can you help?
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
> that support SQL server
all you need is a command line call possibility...

I don't know any, because I never use(d) net send for this kind of messaging, because I only use sms and/or email notifications ...
0
 
kahvedzicAuthor Commented:
Thanks oBdA, just want to check if this is OK in trigger:

in sql server 2000 have:
DECLARE @poruka as char(200)
DECLARE @poruka1 as char(200)
SET @poruka1 = 'net send computer1 ' + ' New text ! '
EXEC master..xp_cmdshell @poruka1, no_output

and in sql server 2008 change it to:
DECLARE @poruka as char(200)
DECLARE @poruka1 as char(200)
SET @poruka1 = 'msg /server:computer1 * ' + ' New text ! '
EXEC master..xp_cmdshell @poruka1, no_output

Is this OK or do I have to change something else?

Thanks
0
 
oBdACommented:
Together with the registry change on the clients, that should do the trick.
0
 
kahvedzicAuthor Commented:
Thank you very much this was really helpful.

Cheers.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.