Thanks a lot Kevin, no more errors:) From: [email protected] [mailto:[email protected]] On Behalf Of Kevin Holman Sent: 19 February 2014 14:49 To: [email protected] Subject: [msmom] RE: SQL Error 777980008, severity 16, state 1
Sure - you can just add that one - but you are missing all the messages, so why wouldn't you just add them all? From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Dominique Dusabeyezu Sent: Wednesday, February 19, 2014 2:28 AM To: [email protected]<mailto:[email protected]> Subject: [msmom] SQL Error 777980008, severity 16, state 1 Importance: High Good day all, Infrastructure: SCOM 2012 SP1, SQL 2008 R2 A bit of background, I have moved the SCOM DB to new hardware, followed the guide and everything seems to work well, though I'm receiving a lot of SQL errors as below: Error 777980008, severity 16, state 1 was raised, but no message with that error number was found in sys.messages. If error is larger than 50000, make sure the user-defined message is added using sp_addmessage. A couple of articles online are mentioning that CLR functions must be enabled, which I have done. I also downloaded a script from Kevin Holman's blog at: http://blogs.technet.com/b/kevinholman/archive/2010/10/26/after-moving-your-operationsmanager-database-you-might-find-event-18054-errors-in-the-sql-server-application-log.aspx My question is, can I only copy the line that refers to that error and run it, instead of running the whole script? That would be: -- Health service should not generate data about this managed object. EXECUTE sp_addmessage @msgnum = 777980008, @msgtext = N'Health service ( %s ) should not generate data about this managed object ( %s ).', @severity = 16, @lang = 'us_english', @with_log = false, @replace = 'REPLACE' GO Your help would me much appreciated. Best regards, Dominique. ________________________________ ---------------------------------------------------------------------------------- Tshwane University of Technology ---------------------------------------------------------------------------------- This email is sent and received in terms of the Electronic Communications Policy of Tshwane University of Technology. In line with this policy, this email is private, privileged and confidential. The full text of the Electronic Mail Disclaimer can be seen on the TUT web site at http://www.tut.ac.za/Other/disclaimer/Pages/default.aspx or obtained by phoning (012) 382-5911 ________________________________ ---------------------------------------------------------------------------------- Tshwane University of Technology ---------------------------------------------------------------------------------- This email is sent and received in terms of the Electronic Communications Policy of Tshwane University of Technology. In line with this policy, this email is private, privileged and confidential. The full text of the Electronic Mail Disclaimer can be seen on the TUT web site at http://www.tut.ac.za/Other/disclaimer/Pages/default.aspx or obtained by phoning (012) 382-5911
