CREATE procedure tng_senderror (@errno int = null)
as
declare @str varchar(255)
if @errno = 40040
select @str = 'MSG:('+convert(varchar(8), @errno)+') Warning: The subnet is already specified. '
else
select @str = 'MSG:('+convert(varchar(8), @errno)+') Senderror: An unknown error has occurred.'
raiserror @errno @str
return
GO
GRANT EXECUTE ON [dbo].[tng_senderror] TO [uniadmin]
GRANT EXECUTE ON [dbo].[tng_senderror] TO [wvadmin]
GO