A stored procedure cannot interact with user. The best it can do is RAISERROR or send email. It's client side responsibility to interact with user.

>
>I'm at a site where they are running running some stored procedures via osql.
>
>How can I return a message to the users desktop from the stored procedure.
>
>ie something like a messagebox.
>
>Alternativerly how else could I provide access to the stored procedure.
>
>Thanks
>
>Nick