sqlKuery provides a graphical UI for MSDE and SQL Server database administration and querying. sqlKuery was developed Visual Basic 6 SP5.
The sqlKuery main window contains a left pane and a right pane. The left pane is a listview displaying hosts selected from /etc/hosts and their MSDE and SQL Server database objects.
The right pane includes a host selection combobox, a database selection combobox, a multiline edit box for entering a SQL query and a table for viewing query results (if any). A small push-button with a "down arrowhead" image is provided just to the right of the label, "Query", above the multiline edit box. Clicking on this button causes the multiline edit box to be overlaid by a listbox containing recent queries (i.e. the recent query history) from which the user may select by double-clicking.
On executing sqlKuery, the user should first supply a MSDE and SQL Server UserName (e.g. sa) and password, and then click Login. The supplied login name and password determine which MSDE and SQL Server database objects are visible and accessible. If no UserName is supplied, Login is attempted using NT Integrated Security rather than SQL Server security.
After a successful Login, database objects will be displayed as a tree view in the left pane. This view may be expanded and operations performed on the objects by clicking on their types or names and selecting actions from the displayed popup menus. In the right pane, the Hosts and Databases combo boxes will be populated. The user may select from these, execute SQL queries and view their results.