Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server Query Tool?
Message
 
To
13/08/2004 10:34:10
General information
Forum:
Visual FoxPro
Category:
Third party products
Miscellaneous
Thread ID:
00933134
Message ID:
00933205
Views:
25
>We need an easy-to-use tool that would allow one or two of our junior developers to query, and only query, a SQL Server database.
>
>We have Entreprise Manager on other desktops but our DBA's fear it is too powerful a tool for our junior developers (and have not intention of spending any time setting up permissions).
>
>Several tables contain about 5-20 GB if that's of any help.
>
>Any suggestions?
>
>TIA,
>Daniel

There is a tool called exactly the same as your title, namely, SQL Server Query. It is just a tool that comes with SQL Server that allows you to run any SQL statement.

Now, security is still an issue, so be sure the DBA sets proper permissions. Alternatively, if they are running Win 2K or above as their workstation, you can create a local SQL Server, have it run on their personal workstation and create a database and restore data from production. Then, you can let them do whatever they want, since the data with be real, but not be production. And whenever, they screw it up, just restore the database as needed.

HTH
Previous
Reply
Map
View

Click here to load this message in the networking platform