ASP SQL Server Explorer

Category:
ASP, HTML and XML
Type:
Applications
Difficulty:
Advanced
Author:
Srdjan

Version Compatibility: ASP

More information:
This is an ASP implementation of the VB SQL Server Explorer project at http://www.freevbcode.com/ShowCode.Asp?ID=1761. It allows you to explore SQL Server data and objects in your web browser. You can also run queries against the database directly from the browser. The application works through calls to the SQL-DMO library.

Important Note: The application includes the ability to select a table and view all of its data in grid format. If the table is very large, the application (and possibly the client or server machine) will hang. Thus, if you are going to deploy this application in production, you should be cautious about using this feature.

All other features worked fine in FreeVBCode.com's testing, and we found it to be an very good example of using SQL-DMO in an ASP application, which can be a powerful tool if used carefully.


Instructions: Click the link below to download the code. Select 'Save' from the IE popup dialog. Once downloaded, open the .zip file from your local drive using WinZip or a comparable program to view the contents.

Download aspsqlexplorer.zip