Wednesday, January 20, 2010


How To Create Web Pages Using Wizard From SQL Server Data | Using Web Assistant Wizard In SQL Server

Using the Web Assistant Wizard
You can use the Web Assistant Wizard to generate standard HTML files from Microsoft® SQL Server™ data. The Web Assistant Wizard generates HTML files by using Transact-SQL queries, stored procedures, and extended stored procedures. You can use the wizard to generate an HTML file on a one time basis or as a regularly scheduled SQL Server task. You also can update an HTML file using a trigger.

With the Web Assistant Wizard, you can:
  • Schedule a task to update a Web page automatically. For example, you can update a price list when a new item is added or a price is changed, thereby maintaining a dynamic inventory and price list for customers and sales staff.
  • Publish and distribute management reports, including the latest sales statistics, resource allocations, or other SQL Server data.
  • Publish server reports with information about who is accessing the server currently, and about which locks are being held by which users.
  • Publish information outside of SQL Server using extended stored procedures.
  • Publish server jump lists using a table of favorite Web sites.
  • Use the sp_makewebtask stored procedure to generate an HTML file. This system stored procedure can be called by a Transact-SQL program. You can also call system stored procedures to run or drop the task. 
The Web Assistant Wizard runs from SQL Server Enterprise Manager. 

Configuring the Web Assistant Wizard
Before running the Web Assistant Wizard, you must:
  • Set appropriate permissions.
  • Choose the database to publish.
  • Create queries. 
Setting Permissions
To run the Web Assistant Wizard, you must have:
  • CREATE PROCEDURE permissions in the selected database.
  • SELECT permissions on chosen columns.
  • Permissions to create files in the account in an instance of Microsoft® SQL Server™.
Choosing the Database to Publish
The Web Assistant Wizard works with databases created by SQL Server. Select the database to publish in the console tree of SQL Server Enterprise Manager. If the server does not appear in this list, run the Register Server Wizard. 

Creating Queries
You can run queries by:
  • Using tables and columns you specify.
  • Creating result sets from a stored procedure.
  • Selecting data using Transact-SQL statements. 
The Web Assistant Wizard requires that each job be named, and a default name is supplied. For jobs that will run at a later time or for jobs that run on a continuous basis, choose a name that will help you remember the focus of this query.  

Receiving Query Results with the Web Assistant Wizard
To receive query results, use your own HTML template file. A template file is any HTML file with the marker <%insert_data_here%> to indicate where the query results should be inserted. If you use an alternate character set, you must insert the necessary meta tag information into the Web page manually, specifying the character chosen.


About bench3 -

Haja Peer Mohamed H, Software Engineer by profession, Author, Founder and CEO of "bench3" you can connect with me on Twitter , Facebook and also onGoogle+

Subscribe to this Blog via Email :