Is it possible to run sp_makewebtask without being a member of the sysadmin role using sql2k SP4?
I have tried creating a custom stored proc based on the sp_makewebtask and commented out the sysadmin check, but I still receive the error: "SQL Web Assistant: Could not open the template file".
When I run the same custom stored proc as a sysadmin, it all works fine, as expected.
I'm pretty sure this same process used to work prior to SP4, so any ideas to work around this security issue will be much appreciated.
Paul.