Stored procedure

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Alan

    Stored procedure

    If I created a stored procedure such as aa_procedure, how the other user
    refer to this procedure ?


  • Oscar Santiesteban Jr.

    #2
    Re: Stored procedure

    If you created it as the "dbo" and you have given "public" the rights to
    execute the procedure, then a user can execute the procedure with the
    following code.

    exec aa_procedure

    Try it in query analyzer.


    "Alan" <alanpltse@yaho o.com.au> wrote in message
    news:3f402203$1 @news.comindico .com.au...[color=blue]
    > If I created a stored procedure such as aa_procedure, how the other user
    > refer to this procedure ?
    >
    >[/color]


    Comment

    Working...