Very Computer

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
returned:

Server: Msg 16882, Level 11, State 1, Line 0
SQL Web Assistant: Web task not found. Verify the name of the task for possible
errors.

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?

Thanks,
JAMIE

--
Regards,

Don R. Watters
Data Group Manager
PhotoWorks, Inc.

Quote:> 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
> procedure.

> 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
> returned:

> Server: Msg 16882, Level 11, State 1, Line 0
> SQL Web Assistant: Web task not found. Verify the name of the task for
possible
> errors.

> 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?

> Thanks,
> JAMIE

This is the command line I get the error message.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!