<div>
Thanks for your responses guys. I'll go through these options shortly and get back to you.<br />
<br />
Many thanks for the quick responses.<br />
<br />
R.
</div>


Thanks for your responses guys. I'll go through these options shortly and get back to you.

Many thanks for the quick responses.

R.

<div>
Many thanks gents. I am working through the options.<br />
Thanks especially for the links hence the extra points.<br />
<br />
R.
</div>


Many thanks gents. I am working through the options.
Thanks especially for the links hence the extra points.

R.

<div>
<div class="content wysiwyg-content">
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? <br />
What client tools can I use for this purpose? I don't mind a little bit of programming.<br />
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.
</div>
</div>


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.

Running a SQL Server Stored Procedure as a user

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Windows Server 2012 is the server version of Windows 8 and the successor to Windows Server 2008 R2. Windows Server 2012 is the first version of Windows Server to have no support for Itanium-based computers since Windows NT 4.0. Windows Server 2012, now in its second release (Windows Server 2012 Release 2) includes Foundation, Essentials, Standard and Datacenter, and does not support IA-32 or IA-64 processors.

Windows Server 2012

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.