[dbo].[ADD_UND

Property	Value
ANSI Nulls On
Quoted Identifier On

Name	Data Type	Max Length (Bytes)
@name_1	nvarchar(50)	100
@nic_card_2	nvarchar(50)	100
@description_3	nvarchar(50)	100
@address_4	nvarchar(50)	100
@status_5	nvarchar(20)	40

Type	Action	Owning Principal
Grant	Execute	uniadmin
Grant	Execute	uniuser

SQL Script

/****** Object:  Stored Procedure dbo.ADD_UND_PROBE    Script Date: 12/1/2005 11:49:11 PM ******/

/****** Object:  Stored Procedure ADD_UND_PROBE    Script Date: 3/25/2005 2:24:50 PM ******/
CREATE PROCEDURE [ADD_UND_PROBE]
    (@name_1     [nvarchar](50),
     @nic_card_2     [nvarchar](50),
     @description_3     [nvarchar](50),
     @address_4     [nvarchar](50),
     @status_5     [nvarchar](20))

AS INSERT INTO [srdb].[und_probe]
     ( [name],
     [nic_card],
     [description],
     [address],
     [status],
    [dt_created])

VALUES
    ( @name_1,
     @nic_card_2,
     @description_3,
     @address_4,
     @status_5,
    getdate())
GO
GRANT EXECUTE ON  [dbo].[ADD_UND_PROBE] TO [uniadmin]
GRANT EXECUTE ON  [dbo].[ADD_UND_PROBE] TO [uniuser]
GO