Post reply

Error no. with no mesaage. Interesting!

  • April 6, 2008 at 1:18 am

    #123282

    Hello All,

    This morning, log file of one my database got full, and in the process to shrink it, I took the Tlog backup. The Tlog backUp process was taking longer time, so I tired to change the recovery model of the DB to simple instead, but it did not let me change the model. since then I am getting the following error number with no error msg. Finally I was able to take Tlog backup and shrink the file. Now the DB is in simple recovery mode.

    Error: 18054, Severity: 16, State: 1.

    Error 90005, severity 17, 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.

  • April 6, 2008 at 9:15 pm

    #798913

    Good to know you resolved it.

    [font="Verdana"]--www.sqlvillage.com[/size][/font]

  • April 6, 2008 at 10:29 pm

    #798925

    [font="Tahoma"]Can you execute the below query and check whether user defined messages are there in the server.

    select * from sys.messages where message_id=90005

    [/font]

    Regards..Vidhya Sagar
    SQL-Articles

  • August 14, 2008 at 5:48 pm

    #858505

    Hi

    I have got same message with different Error number and i could not find the Error number 300101 in my message table. I know that SQL Server generate these messages when it has no message template on message tables, but how we can find the event that end up generating this message?

    Any idea?

    thanks , nahid :doze:

  • October 17, 2008 at 3:51 pm

    #886696

    Anybody resolved this issue? Im also facing this issue.

    Thanks

    Jay.

    Thanks
    Jay
    http://www.sqldbops.com

  • March 26, 2009 at 7:26 am

    #966641

    Has anyone come up with an answer to this problem? I just received the same error after upgrading from SQL Server 2000 to 2005.

  • October 22, 2009 at 9:23 am

    #1069484

    Hi, check out:

    http://blogs.technet.com/mgoedtel/archive/2007/08/06/update-to-moving-operationsmanager-database-steps.aspx

  • December 23, 2009 at 4:13 am

    #1095859

    Hi

    I'm getting an error as shown below:

    Error 778263, 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.

    Hi, check out:

    http://blogs.technet.com/mgoedtel/archive/2007/08/06/update-to-moving-operationsmanager-database-steps.aspx

    I used the sql file and altered it so error 778263 is now also added.

    But i still don't know what kind of error this is. Can anyone help me?

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply