microsoft.public.cert.mcdba - Stored procedure

Author

Stored procedure

Alan

2003-08-17, 9:24 pm

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

Ray Higdon

2003-08-17, 9:24 pm

If you are a DBO, "exec aa_procedure", if you are not a DBO, exec
yourusername.aa_procedure

If you have assigned parameters to the stored proc they can call these in
order or by specifying the param name.

HTH

--
Ray Higdon MCSE, MCDBA, CCNA
---
"Alan" <alanpltse@yahoo.com.au> wrote in message
news:u1UePISZDHA.2284@TK2MSFTNGP12.phx.gbl...
> And also, if I created a stored procedure such as aa_procedure, how the
> other user refer to this procedure ?
>
>

Sponsored Links