What do I need? 1

[onyxtacular]

Hi Everyone,
I'm new to SQL and have been tasked with creating an "app" where the user can run a query to our 2012 SQL server with the click of the mouse. Our old db was Pervasive SQL and there was a way for the users to access the db on their desktop...sometimes with horrible results.

What I would like is a way to run a query to update specific tables. I can already run the queries on the sql server myself but I need to have the average authorized user run the query on their desktop.

If someone could point me in the right direction I would appreciate it greatly.

Thanks,

 

[gmmastros]

It depends on what you expect from the query you execute from the user's desktop.

You can install SQL Server Management Studio on your user's desktops. If you do this, you are legally allowed to install the management studio, but not the database engine (unless you are using SQL Express). Beware though, if you follow this route, your users may have access to too much information and too much functionality unless you lock down permissions. This is probably your worst option, but it bears mentioning.

If you only need to execute an update type of query, you could create a batch script utilizing SQLCMD (which is a free command line utility).

If you want your users to retrieve data and they have something like Microsoft Excel already installed, you could create a spreadsheet that queries the database and displays results.

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[onyxtacular]

Thanks for your post. I've read through

https://msdn.microsoft.com/en-us/library/ms162773.aspx

and this looks like it may work for what I would like to do.