I am writing Stored Procedures in SQL Server 2012 and I would like to give a user without knowledge of SQL Server access to run this SP. What are my options?
What client tools can I use for this purpose? I don't mind a little bit of programming.
Ideally I want this user to click an icon on the desktop and be presented with the SP or a list of SPs to execute them.