Run query without sql server (2000)

Hi all,
I wrote a query in SQL server query analyser and would like a user to run th
is regularly. However it’s not possible to give them SQL server. Can they
do this another way i.e. through Access or similar?
Many thanks
IGYou could just install sql server client utilities (without the server).
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Igloo" <anonymous@.discussions.microsoft.com> wrote in message
news:218EDD05-8623-4B1C-9835-4A3CB384C7CE@.microsoft.com...
Hi all,
I wrote a query in SQL server query analyser and would like a user to run
this regularly. However it's not possible to give them SQL server. Can they
do this another way i.e. through Access or similar?
Many thanks
IG|||You must install the SQL client connectivity piece for them to use SQL OR
Create some middle tier object with access and let them use the middle tier
object
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Igloo" <anonymous@.discussions.microsoft.com> wrote in message
news:218EDD05-8623-4B1C-9835-4A3CB384C7CE@.microsoft.com...

quote:

---

> Hi all,
> I wrote a query in SQL server query analyser and would like a user to run

---

this regularly. However it's not possible to give them SQL server. Can they
do this another way i.e. through Access or similar?

quote:

---

> Many thanks
> IG
>

---

|||You can install ODBC on the client, create a data source pointing back to yo
ur SQL database, create your query as a view on your SQL box, then use Acces
s to link the view as a table/data source. I do it all the time for user re
porting. It provides data
integrity because you can make the view read-only so users can't change the
data, and the users can only see what you let them, so you have data securit
y.
It's also a good way to make ad hoc query tools when you want to provide the
intelligence so that the users don't have to learn SQL.