Troubleshooting the Web Assistant Wizard

This section 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. This is accomplished by building an INSERT, UPDATE, and DELETE trigger for each of the tables selected by the user. 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_tableObjectId_1 -> INSERT trigger

Web_tableObjectId_2 -> UPDATE trigger

Web_tableObjectId_4 -> DELETE trigger

For example, if the authors table from the pubs database is selected as one of the tables to be considered when the data changes, the three triggers generated by the Web Assistant Wizard will be: Web_16003088_1, Web_16003088_2, and Web_16003088_4 for the INSERT, UPDATE, and DELETE respectively (where 16003088 is the object ID corresponding to the authors table in the pubs database).

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 ID for the table in question:

   SELECT OBJECT_ID('tabName') tabObjId

2. List all the triggers for this table object:

   USE master

   GO

   SELECT *

   FROM sysobjects

   WHERE name LIKE 'Web_tabObjId%'

   GO

3. Run the DROP TRIGGER command for each of the triggers you want to drop:

   DROP TRIGGER <Webtriggername>

See Also