Error After SQL Server 2005 SP1

SQL Server 2005 SP1 Build 2153 Developer Edition on Windows 2003 Server SP1
When I start the SQL Server service I get:
[298] SQL Server Error: 2812, Could not find stored procedure
'msdb.dbo.xp_sqlagent_notify'. [SQLSTATE 42000] (DisableAgentXPs)
Any ideas?
Thanks,
Bryansp1 build is 2047. you must have installed the post sp1 hotfix rollup.
please follow http://support.microsoft.com/Default.aspx?id=918222 to ensure
you have properly install the hotfix in the specified order.
-oj
"BDB" <bdb@.reply.to.group.com> wrote in message
news:%23xzEM2IkGHA.3780@.TK2MSFTNGP03.phx.gbl...
> SQL Server 2005 SP1 Build 2153 Developer Edition on Windows 2003 Server
> SP1
>
> When I start the SQL Server service I get:
> [298] SQL Server Error: 2812, Could not find stored procedure
> 'msdb.dbo.xp_sqlagent_notify'. [SQLSTATE 42000] (DisableAgentXPs)
>
> Any ideas?
> Thanks,
> Bryan
>|||sp1 build is 2047. you must have installed the post sp1 hotfix rollup.
please follow http://support.microsoft.com/Default.aspx?id=918222 to ensure
you have properly install the hotfix in the specified order.
-oj
"BDB" <bdb@.reply.to.group.com> wrote in message
news:%23xzEM2IkGHA.3780@.TK2MSFTNGP03.phx.gbl...
> SQL Server 2005 SP1 Build 2153 Developer Edition on Windows 2003 Server
> SP1
>
> When I start the SQL Server service I get:
> [298] SQL Server Error: 2812, Could not find stored procedure
> 'msdb.dbo.xp_sqlagent_notify'. [SQLSTATE 42000] (DisableAgentXPs)
>
> Any ideas?
> Thanks,
> Bryan
>|||Hi, Thank you for your post.
We were aware and followed KB918222 prior to bringing the build to 2153. It
does not appear to be related.
"oj" <nospam_ojngo@.home.com> wrote in message
news:%233htVgRkGHA.4304@.TK2MSFTNGP03.phx.gbl...[vbcol=seagreen]
> sp1 build is 2047. you must have installed the post sp1 hotfix rollup.
> please follow http://support.microsoft.com/Default.aspx?id=918222 to
> ensure you have properly install the hotfix in the specified order.
> --
> -oj
> "BDB" <bdb@.reply.to.group.com> wrote in message
> news:%23xzEM2IkGHA.3780@.TK2MSFTNGP03.phx.gbl...|||Take a closer look at msdb..sp_sqlagent_notify stored procedure. The
execution line should be:
EXECUTE @.retval = master.dbo.xp_sqlagent_notify @.op_type, @.job_id,
@.schedule_id, @.alert_id, @.action_type, @.nt_user_name, @.error_flag,
@.@.trancount, @.wmi_namespace, @.wmi_query
-oj
"BDB" <bdb@.reply.to.group.com> wrote in message
news:%23sVMFlVkGHA.5108@.TK2MSFTNGP02.phx.gbl...
> Hi, Thank you for your post.
> We were aware and followed KB918222 prior to bringing the build to 2153.
> It does not appear to be related.
> "oj" <nospam_ojngo@.home.com> wrote in message
> news:%233htVgRkGHA.4304@.TK2MSFTNGP03.phx.gbl...
>|||Hi, Thank you for your post.
We were aware and followed KB918222 prior to bringing the build to 2153. It
does not appear to be related.
"oj" <nospam_ojngo@.home.com> wrote in message
news:%233htVgRkGHA.4304@.TK2MSFTNGP03.phx.gbl...[vbcol=seagreen]
> sp1 build is 2047. you must have installed the post sp1 hotfix rollup.
> please follow http://support.microsoft.com/Default.aspx?id=918222 to
> ensure you have properly install the hotfix in the specified order.
> --
> -oj
> "BDB" <bdb@.reply.to.group.com> wrote in message
> news:%23xzEM2IkGHA.3780@.TK2MSFTNGP03.phx.gbl...|||Take a closer look at msdb..sp_sqlagent_notify stored procedure. The
execution line should be:
EXECUTE @.retval = master.dbo.xp_sqlagent_notify @.op_type, @.job_id,
@.schedule_id, @.alert_id, @.action_type, @.nt_user_name, @.error_flag,
@.@.trancount, @.wmi_namespace, @.wmi_query
-oj
"BDB" <bdb@.reply.to.group.com> wrote in message
news:%23sVMFlVkGHA.5108@.TK2MSFTNGP02.phx.gbl...
> Hi, Thank you for your post.
> We were aware and followed KB918222 prior to bringing the build to 2153.
> It does not appear to be related.
> "oj" <nospam_ojngo@.home.com> wrote in message
> news:%233htVgRkGHA.4304@.TK2MSFTNGP03.phx.gbl...
>|||Hi, Thanks for following up! On inspection of msdb.dbo.sp_sqlagent_notify
source the calling semantics of master.dbo.xp_sqlagent_notify are the same
as what you specified.
"oj" <nospam_ojngo@.home.com> wrote in message
news:uJB6qmWkGHA.3588@.TK2MSFTNGP02.phx.gbl...[vbcol=seagreen]
> Take a closer look at msdb..sp_sqlagent_notify stored procedure. The
> execution line should be:
> EXECUTE @.retval = master.dbo.xp_sqlagent_notify @.op_type, @.job_id,
> @.schedule_id, @.alert_id, @.action_type, @.nt_user_name, @.error_flag,
> @.@.trancount, @.wmi_namespace, @.wmi_query
> --
> -oj
> "BDB" <bdb@.reply.to.group.com> wrote in message
> news:%23sVMFlVkGHA.5108@.TK2MSFTNGP02.phx.gbl...|||Hi, Thanks for following up! On inspection of msdb.dbo.sp_sqlagent_notify
source the calling semantics of master.dbo.xp_sqlagent_notify are the same
as what you specified.
"oj" <nospam_ojngo@.home.com> wrote in message
news:uJB6qmWkGHA.3588@.TK2MSFTNGP02.phx.gbl...[vbcol=seagreen]
> Take a closer look at msdb..sp_sqlagent_notify stored procedure. The
> execution line should be:
> EXECUTE @.retval = master.dbo.xp_sqlagent_notify @.op_type, @.job_id,
> @.schedule_id, @.alert_id, @.action_type, @.nt_user_name, @.error_flag,
> @.@.trancount, @.wmi_namespace, @.wmi_query
> --
> -oj
> "BDB" <bdb@.reply.to.group.com> wrote in message
> news:%23sVMFlVkGHA.5108@.TK2MSFTNGP02.phx.gbl...|||there must be a process/procedure that calls 'msdb.dbo.xp_sqlagent_notify'.
run this to see if anything returns.
exec sp_msforeachdb "select '?';use ?; select object_name(object_id) n from
?.sys.sql_modules where definition like '%msdb.dbo.xp_sqlagent_notify%'"
-oj
"BDB" <bdb@.reply.to.group.com> wrote in message
news:uFvh$UXkGHA.2200@.TK2MSFTNGP05.phx.gbl...
> Hi, Thanks for following up! On inspection of
> msdb.dbo.sp_sqlagent_notify source the calling semantics of
> master.dbo.xp_sqlagent_notify are the same as what you specified.
> "oj" <nospam_ojngo@.home.com> wrote in message
> news:uJB6qmWkGHA.3588@.TK2MSFTNGP02.phx.gbl...
>