Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
KlausEngel
Yak Posting Veteran
85 Posts |
 Posted - 2010-07-07 : 15:39:12
|
| I have to run a simple SELECT statement against 1 table on my database. I need this statement to be executed by a user that doesn't have database access and I just need the values of one column to be returned in any kind of list form. What's the best way to go about this? Any help would be appreciated. |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2010-07-07 : 15:45:54
|
| Access with a listview is the best. Either access adp or mdb. with adp the connection is direct no need for linked tables and all. with mdb you will have to do linked tables and/or views. you will of course have to lock down these databases so user does not edit tables directly. Or better yet you could it with Excel.<><><><><><><><><><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
 |
|
|
KlausEngel
Yak Posting Veteran
85 Posts |
Posted - 2010-07-07 : 20:44:24
|
| Thank you. |
|
|
|
|
|
|
Execute query outside of Management Studio