Raiserror and Net Send
hallo everyone
i'm trying to setup a net send message via a raiserror, on a SQL 2000 STD.
I'd like to clarify the use of "gravity" parameter.
I have a custom alert, and using RAISERROR with it into SQL Query Analyzer, i noticed that i can trigger a NET SEND only with gravity values greater than 18.
I cannot find documentation about it.
The only thing i read around about the 18-value threshold is that beyond that number, the alert is considered an error and can be triggered only by members of 'sysadmin' role and only if using "WITH LOG".
Is there any way to launch a net send with values smaller than 19?
I want to avoid using xp_cmdshell for permissions.
thanks in advance
Look like this is by design.
These are the circumstances under which errors/messages generated by SQL
Server and SQL Server applications are sent to the Windows NT application log
and can therefore raise alerts:
- Severity 19 or higher sysmessages errors
- Any RAISERROR statement invoked with WITH LOG syntax
- Any sysmessages error modified or created using
sp_altermessage
- Any event logged using xp_logevent
oj at 2007-9-3 >
sorry to kill the joy
net send is not a recommended way of sending notifications
as you can see windows server 2003 has net send turned off
beside net send message might get lost somewhere along the lines
how about considering xp_sendmail instead
reagrds
ok let's consider i want to accept the recommendations, and let net send turned off.
i need to alert some intranet front-office clients (machines/ logged users).
Is there any alternative built-in method to popup a message box to them?
