Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Server Query Tool?
Message
 
À
13/08/2004 10:34:10
Information générale
Forum:
Visual FoxPro
Catégorie:
Produits tierce partie
Divers
Thread ID:
00933134
Message ID:
00933205
Vues:
24
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform