Best way of allowing user to run a query?

[Wyldcard9]

I am thinking about allowing a user to run a query, so they can get the results whenever they want. Problem is, I do not want to give them Query Analyzer. Is there another way of allowing them to run a query? Can I run it from another program?

 

[SQLSister]

i would suggest creating a user interface and encapsulating the query in a stored procedure. Then you can give the user rights to the stored procedure and have the user inteface exec the stored procedure. YOu can also dynamically send parameters from a form this way to make a query more specific.

Questions about posting. See faq183-874

 

[Wyldcard9]

SQLSister,
Thanks

 

[mrdenny]

You might want to look at creating an ASP page for the user. It's much easier to create and update, since you don't have to tell the user to go get the updated version. Also you don't have to compile it, and send it to the user. You just send them a URL, and let IIS worry about the login info.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[Wyldcard9]

mrdenny,

Thanks

I went with Excel. Data/Get External Data/New Database Query. After I set it up once on their machine, they just have to Run Saved Query.