Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Enterprise
Expertise: Beginner
May 13, 2002

Send NET SEND Messages


This code is how to send NET SEND messages to all the connected SQL Server users in an NT local area network:
 
CREATE PROC notify_users
(
@notification VARCHAR(100) = 'SQL Server shutting down'
)
AS
BEGIN

SET NOCOUNT ON

DECLARE @msg VARCHAR(250)
DECLARE @hostname sysname

SELECT @hostname= min(RTRIM(hostname))
FROM
  master.dbo.sysprocesses (NOLOCK)
WHERE
  hostname <> ''

WHILE @hostname is not null
    BEGIN
	set @msg='exec master.dbo.xp_cmdshell "net send ' 
+ RTRIM(@hostname) + '
' + RTRIM(@notification) + ' "'
        EXEC (@msg)
  	SELECT @hostname= min(RTRIM(hostname))
	FROM
  		master.dbo.sysprocesses (NOLOCK)
	WHERE
  		hostname <> ''
		and hostname > @hostname
    END

SET NOCOUNT OFF

END
NageswaraRao Kurra
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date