Troubleshooting the Web Assistant Wizard

This topic describes how the Web Assistant Wizard handles HTML page generation using the When the SQL Server data changes scheduling option.

With the Web Assistant Wizard, you can generate an HTML file whenever the data changes for one or more tables by using the Schedule the Web Assistant Job dialog box and selecting When the SQL Server data changes. The Web Assistant Wizard will accomplish this by either building new INSERT, UPDATE, and DELETE triggers for each of the tables selected by the user or updating existing ones. Any existing triggers are detected automatically by the Web Assistant Wizard and retained. Additional Transact-SQL statements are appended to the existing trigger code.

The trigger object built by the Web Assistant Wizard will have a name generated according to the following:

Web Page Name_1 -> INSERT trigger
Web Page Name_2 -> UPDATE trigger
Web Page Name_4 -> DELETE trigger

For example, if the page you create is named "Web Page 1", the three triggers generated by the Web Assistant Wizard will be: Web Page 1_1, Web Page 1_2, and Web Page 1_3 for the INSERT, UPDATE, and DELETE triggers respectively.

sp_depends does not enlist any of the Web Assistant Wizard generated triggers for a given table. You can use sp_helptrigger to return trigger information for the specified table for the current database.

Use the following steps to drop any of the triggers generated by the Web Assistant Wizard:

1. Identify the object name of all triggers to be dropped by executing the sp_helptrigger system stored procedure.

   sp_helptrigger TableName
   GO
   

2. Execute the DROP TRIGGER statement for each of the triggers you want to drop:

   DROP TRIGGER WebTriggerName