ASP is a goodway to fetch data, manipulate data and create data definition objects on a remote database.
But you cannot say ASP is confined to only remote database manipulation.
It can do many things like, remote file opeartions, mail sending / retrieving, LDAP, Retrieving HTML form data and file uploads and many many other things.
ASP is a scripting environment in which you can do scripting with a number of scripting languages like VBScript, JScript etc. etc. ASP provides some basic objects which are very essential for web programming. They are Request, Response, Session, Application, Server and Object Context Object. They can be directly accessed by any of these scripting languages.
You can extend ASP with the help of thrid party components like components for file upload handling, FTP, Remote server communication etc. etc.