devxlogo

Send NET SEND Messages

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')ASBEGINSET NOCOUNT ONDECLARE @msg VARCHAR(250)DECLARE @hostname sysnameSELECT @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    ENDSET NOCOUNT OFFEND
See also  5 Tips for Choosing the Right Medical Software for Your Practice
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist