Summary
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.