Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-02-18 : 09:28:41
|
| Erikson writes "SQL Server 7.WINNT 4. SP 5.I created a web task in SQL 7 that updates a page (regcount.htm) whenever the "data in sql changes". A trigger was automatically created under the concerned table.I then deleted this task. The task was deleted succesfully and so was the generated job and stored procedure. However, the trigger that was created was not deleted.I then proceeded to manually delete it. (R-click on table/all tasks/manage triggers/select the trigger/then delete). This successfully removed the trigger.Now, I am unable to save any new records to this table in the database. I keep getting an error saying: "[Microsoft SQL ODBC driver][web task not found]. Basically behaving as though there still remained a web-update instruction for it to execute whenever a new record was entered (sql data changes).I generated the scripts for the triggers in this table. There is an entry there that is related to the web task that was created.What can I do to be able to remove this "apparent" trigger or instruction to look for a web task so as to bele to insert new records once more.Thanks." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-02-18 : 10:18:23
|
| Can't you just edit that trigger to remove the web task reference? Until you drop that trigger or modify it to remove the task you will keep getting this error.Edited by - robvolk on 02/18/2002 10:19:17 |
 |
|
|
|
|
|
Error: Web Task Not found.