We have switched servers. Moved the SQL database from one server to an
upgraded one. All system and domain names are the same. One of my DTS
Packages calls a stored procedure which calls a system (sp_...) stored
The command is "EXEC sp_runwebtask ' ', 'f:\MSSQL\HTML\RateChart.htm'.
This has worked and still works on the old server, but not the new. The file
listed exists in the stated drive and folder. The following error message is
Server: Msg 16882, Level 11, State 1, Line 0
SQL Web Assistant: Web task not found. Verify the name of the task for possible
There are no triggers in the database. I dropped the stored procedure (the one
I've written) and re-created it. I checked all the SQL and Windows NT rights
and permissions. They all look fine.
Does anyone have any ideas on how to solve this problem?