Hi Guys,

I am thinking how i can solve my problem. I am thinking if someone can help me with my this question.

Let say here is my SP

Create Procedure Test

@Variable1 int

as

Select * from mytable

where @Variable1 = Variable1

--Here is my question

Declare @VariableName int

Set @VariableName = (Is there way when this SP runs i can get the name of the SP with Variable?)

PRINT @VariableName

Please guide me. Thank You.