>>>Thanks Sergey.
>>>
>>>Do you know of any stored procedure launchers that I could use.
>>>
>>>I could write one but I wondered if there is anything I could download.
>>>
>>>
>>The simplest way will be to run the SP from SSMS (SQL Server Management Studio). You can also use sqlcmd
>
>Yes but.
>
>I want users to be able to run some stored procedures and get a message back and I don't want them using the management studio.
>
>Thanks

In this case you need to create an application. I saw recently a very interesting Add-in to Word

http://www.the-business-intelligence-guy.com/2011/05/the-future-of-bi-raw-uncut.html