Stored Procedures [dbo].[tng_senderror]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@errnoint4
Permissions
TypeActionOwning Principal
GrantExecuteuniadmin
GrantExecutewvadmin
SQL Script
/****** Object:  Stored Procedure dbo.tng_senderror    Script Date: 12/1/2005 11:49:13 PM ******/

CREATE procedure tng_senderror (@errno int = null)  
as
declare @str varchar(255)
/* select @str = description from topmessages where error = @errno */
/* if @@rowcount != 1  */
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
Uses