Code Details

VB Component source code and ASP files to test the component are provided with this article. A compiled DLL is also provided. Directly plug in the DLL in your Web application to test the component functionality. Source code is also provided so that you can play with the code yourself and try to add some more features in the component. ASP files are provided to test the component in ASP. Create and remove tasks through these files. To run the ASP files, create a new Web application and include all the ASP files in the new application, and open the index file, tm_demo1.asp, in your browser to test the functionality.

Summary

Creating ASP Component to manage SQL Server remotely is fairly easy. It only requires a basic knowledge of ASP, VB, and SQL Server. The article shows how easy it is to create a component that harnesses the power of SQL-DMO and manages the SQL tasks remotely.