none
Fatal error 9001

    Question

  • USE [cho_news]
    GO

    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO

    CREATE PROCEDURE [cho].[DELETENEWSECTION]
    (
    @newsec_id nvarchar (Max) 
    )
    AS
    BEGIN
    SET NOCOUNT ON
    DELETE newsec_table

    WHERE newsec_id=@newsec_id
    END

    showing error: 

    Msg 21, Level 21, State 1, Procedure DELETENEWSECTION, Line 9
    Warning: Fatal error 9001 occurred at Jun 13 2012 11:50PM. Note the error and time, and contact your system administrator.

    • Moved by Bob Beauchemin Thursday, June 14, 2012 7:35 PM Moved resolved problem to a relevent forum for best searching. (From:.NET Framework inside SQL Server)
    Thursday, June 14, 2012 9:53 AM

Answers

  • the database logs file was full and restarted it to fix

    now its working

    thnx for the help

    • Edited by SSmadhu Thursday, June 14, 2012 12:12 PM
    • Marked as answer by SSmadhu Thursday, June 14, 2012 12:12 PM
    Thursday, June 14, 2012 10:12 AM

All replies

  • Warning: Fatal error 9001 occurred at Jun 13 2012 11:50PM. Note the error and time, and contact your system administrator.

    Strange, if the error number 9001 is the error throw by SQL Server, then it means:
    The log for database '%.*ls' is not available. Check the event log for related error messages. Resolve any errors and restart the database.

    select *
    from sys.messages
    where message_id = 9001 


    Olaf Helper
    * cogito ergo sum * errare humanum est * quote erat demonstrandum *
    Wenn ich denke, ist das ein Fehler und das beweise ich täglich
    Blog Xing

    Thursday, June 14, 2012 10:03 AM
    Moderator
  • the database logs file was full and restarted it to fix

    now its working

    thnx for the help

    • Edited by SSmadhu Thursday, June 14, 2012 12:12 PM
    • Marked as answer by SSmadhu Thursday, June 14, 2012 12:12 PM
    Thursday, June 14, 2012 10:12 AM