June 26, 2009 at 12:20 pm
Dang it... not sure where my previous post went so if it appears twice, I apologize.
First of all, I'm aware that sp_MakeWebTask has been deprecated but I need it to run in a 2k5 instance to support some legacy code until we can move it's output to SSRS.
I've followed the instructions in BOL and have successfully executed the following code with no errors...
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Web Assistant Procedures', 1;
GO
RECONFIGURE
GO
BOL also states that you have to run the Web.sql script that appears in the SQL Server "install" directory which I've done. However, it returns a pot wad of errors as follows...
Msg 2812, Level 16, State 62, Line 2
Could not find stored procedure 'sp_MS_upd_sysobj_category'.
Configuration option 'allow updates' changed from 0 to 1. Run the RECONFIGURE statement to install.
Msg 2812, Level 16, State 62, Line 2
Could not find stored procedure 'sp_MS_upd_sysobj_category'.
Msg 3701, Level 11, State 5, Procedure sp_dropextendedproc, Line 16
Cannot drop the procedure 'xp_makewebtask', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 5, Procedure sp_dropextendedproc, Line 16
Cannot drop the procedure 'xp_dropwebtask', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 5, Procedure sp_dropextendedproc, Line 16
Cannot drop the procedure 'xp_runwebtask', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 5, Procedure sp_dropextendedproc, Line 16
Cannot drop the procedure 'xp_cleanupwebtask', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 5, Procedure sp_dropextendedproc, Line 16
Cannot drop the procedure 'xp_enumcodepages', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 5, Procedure sp_dropextendedproc, Line 16
Cannot drop the procedure 'xp_convertwebtask', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 5, Procedure sp_dropextendedproc, Line 16
Cannot drop the procedure 'xp_readwebtask', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 5, Line 4
Cannot drop the procedure 'dbo.sp_makewebtask', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 5, Line 2
Cannot drop the procedure 'dbo.sp_dropwebtask', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 5, Line 2
Cannot drop the procedure 'dbo.sp_runwebtask', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 5, Line 2
Cannot drop the procedure 'dbo.sp_cleanupwebtask', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 5, Line 2
Cannot drop the procedure 'dbo.sp_enumcodepages', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 5, Line 2
Cannot drop the procedure 'dbo.sp_convertwebtasks', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 5, Line 3
Cannot drop the procedure 'dbo.sp_readwebtask', because it does not exist or you do not have permission.
Msg 2812, Level 16, State 62, Line 2
Could not find stored procedure 'sp_MS_upd_sysobj_category'.
Msg 2812, Level 16, State 62, Line 3
Could not find stored procedure 'sp_MS_upd_sysobj_category'.
Configuration option 'allow updates' changed from 1 to 0. Run the RECONFIGURE statement to install.
The Web.sql script seems to be looking for the 'dbo.sp_convertwebtasks' stored procedure in MSDB but I can't find it there or in the Master database.
The local server I've tried this on is a SQL Server Developer edition of SQL Server 2005 with sp3. I'm logged in using Windows Authenticaion and I am a member of the SA role.
I've Googled the error and no joy there. There's a couple of listings but none with this type of error. I sure could use your help on this one. Thanks, folks.
--Jeff Moden
Change is inevitable... Change for the better is not.
June 26, 2009 at 12:27 pm
{edit} I still need some help on this because the following didn't work. Please see the 3rd post on this thread. Thanks, folks.
Aw shoot... I guess I'm going as blind as a bat... I found the stored procedure in Master using the filter. Let me make a couple of changes in the script and try again... I'll be back.
--Jeff Moden
Change is inevitable... Change for the better is not.
June 26, 2009 at 12:43 pm
Ah... no joy... I still need some help on this, please. Even though I've found the sp_MS_upd_sysobj_category stored proc in Master and modified the the Web.sql stored procedure that MS provided to do all of this, I'm still getting the follow errors.
Msg 2812, Level 16, State 62, Line 2
Could not find stored procedure 'master.dbo.sp_MS_upd_sysobj_category'.
Configuration option 'allow updates' changed from 0 to 1. Run the RECONFIGURE statement to install.
Msg 2812, Level 16, State 62, Line 2
Could not find stored procedure 'master.dbo.sp_MS_upd_sysobj_category'.
Msg 2812, Level 16, State 62, Line 2
Could not find stored procedure 'master.dbo.sp_MS_upd_sysobj_category'.
Msg 2812, Level 16, State 62, Line 3
Could not find stored procedure 'master.dbo.sp_MS_upd_sysobj_category'.
Configuration option 'allow updates' changed from 1 to 0. Run the RECONFIGURE statement to install.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply