Send message to user with net send?

[gcole]

I have created a trigger that checks the integrity of effective dates on insert and update. I need to notify the user of they are trying to add illegal (my rules) dates. I can't use mail (not setup on server). How do I do this with net send? I have the trigger and the alert.
Thanks,
Gail

 

[bondm007]

I use this in my code all the time...When an email is too much.

Shell "net send " & strUsername & " " & strMessage, vbNormalNoFocus

It has always worked for me...


Mike

 

[gcole]

Are you doing this in T-SQL or VB? I think I can translate it to T-SQL without the vbNormalNoFocus.
Thanks

 

[bondm007]

This was done from within VB...


Mike

 

[gcole]

Do you know the command to get the logged in user? VB or SQL

 

[tlbroadbent]

If you have permission to execute xp_cmdshell you can use the following.

exec master..xp_cmdshell 'net send hostname',no_output Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[gcole]

I wrote the following sp to handle this. It uses the machine name to send the message.

/*

June 7, 2002

Author: Gail Cole

Purpose: Sent a NET message to the logged in user
Inputs: Message to send
Modifed:

*/

CREATE PROCEDURE sp_db_SentNETMessage
@Msg varchar(100)
AS
set nocount on


DECLARE @Cmd as varchar(1000)
DECLARE @Host as varchar (50)

Set @Host = Host_name()

Set @Cmd = 'net send ' + @Host + ' ' + @Msg
execute master..xp_cmdshell @Cmd