Home > IT Answers > Development > SQL Writer error
Chuanilee
5 pts.
 SQL Writer error
SQL, SQL writer, SQL Writer error messages
sql error in the start; either mesup or tempered

Software/Hardware used:
ASKED: January 16, 2009  12:58 AM
UPDATED: January 20, 2009  5:42 PM
RELATED QUESTIONS
Answer Wiki:
When my SQL Server agent starts, I always came across these 2 errors: 1. [298] SQLServer Error: 2812, Could not find stored procedure 'msdb.dbo.xp_sqlagent_notify'. [SQLSTATE 42000] (DisableAgentXPs) 2. [364] The Messenger service has not been started - NetSend notifications will not be sent First one is the error and the second one is the warning... Check the following... as per the following thread it is bug and fixed in SP2... <a href="http://groups.google.com/group/microsoft.public.sqlserver.tools/browse_thread/thread/af9611ae23603a16/80331ad74dee5730?lnk=st&q=Could+not+find+stored+procedure+%27msdb.dbo.xp_sqlagent_notify%27&rnum=1#80331ad74dee5730">http://groups.google.com/group/microsoft.public.sqlserver.tools/browse_thread/thread/af9611ae23603a16/80331ad74dee5730?lnk=st&q=Could+not+find+stored+procedure+%27msdb.dbo.xp_sqlagent_notify%27&rnum=1#80331ad74dee5730</a> Agent can send the alert to an operator through NET SEND, which uses the Messenger service. If the service isn't running/started, then Agent will write this message... You can change the messenger service to start automatically if it is configured start manually...
Last Wiki Answer Submitted:  January 20, 2009  5:42 pm  by  Karl Gechlik   9,815 pts.
All Answer Wiki Contributors:  Karl Gechlik   9,815 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

that is not a very descriptive question…. Can you add some more detail and tell us what exactly is going on?

Thanks

Colin Smith
 845 pts.