CREATED YOUR SMALL ASP

If you are through with your web application containing database, and it requires database, tables, stored procedure, then how would you manually make all this things on your hosting server database account There is a simple step for that, just download this Microsoft SQL Server Database Publishing


Microsoft SQL Server Database Publishing Wizard 1.1-Download the given link and install.
Open your visual studio or visual web developer (can download free Express editions from here Visual studio 2008 Express, VWD 2008 Express), then open your database explorer in the sidebar. Expand your database, if all things are upto date, then right click on it (database server name) and you will a "PUBLISH TO PROVIDER link.." click that.



It has got the options to publish "only table data", or "only stored procedures", or "both database table data and stored procedures”. Make an .sol from it ( the name of file of your choice) and save to any location. This is called sol script file Open your web hosting account database control panel go to "Query analyzer" or "new query" option, copy paste the matter of *.sql file to the query textbox and execute



In a moment you will publish all your data on your hosting account database but be sure don't do this process more than once else it will re-publish the database there, removing all the data of the tables, and your new data will be lost in database. After publish the first time, make sure you only change the stored procedures separately and execute them separately to get them saved. Again i say "To Save new Stored procedure on hosting account don't re-publish all the stored procedures, just add the new stored procedure separately, and execute to SAVE, there is no other option to save it than EXECUTE.